I have a query which has two select statements having different columns.
Example:
SELECT STATE, COUNTRY FROM MYCOUNTRY
SELECT COUNTRY, CURRENCY FROM MYCOUNTRY
EXPECTED OUTPUT IN EMAIL:
STATE COUNTRY
CA USA
London UK
COUNTRY CURRENCY
USA DOLLAR
UK POUND
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