I have a query which has two select statements having different columns.
SELECT STATE, COUNTRY FROM MYCOUNTRY
SELECT COUNTRY, CURRENCY FROM MYCOUNTRY
EXPECTED OUTPUT IN EMAIL:
I am not sure how to get this kind of output. I have over simplified it but each select statements which I have are completely unrelated and cannot be merged in any way. USERS do not want multiple emails and want data in one email output.
If you can create a dashboard containing those two queries as separate panels, you could schedule delivery of a dashboard view in PDF format. Would that meet your goals? If so, the exact process will vary based on the version of Splunk you are running, but here's a link to documentation for the current Splunk version: http://docs.splunk.com/Documentation/Splunk/7.0.1/Viz/DashboardPDFs