I have a Dashboard with multiple Panels with statistics results and each Panel containing different set of columns, my requirement is to export all the panels into a single spreadsheet(csv file) so that the user can see all the tables in CSV file instead of going to SPlunk UI
In each panel, add XML like this (incrementing the
Panel2, etc.) :
<init> <unset token="Panel1SID"></unset> </init> <done> <set token="Panel1SID">"$job.sid$"</set> </done>
Then in a final (new) panel you can do something like this:
<query>|loadjob $Panel1SID$ | appendpipe [|loadjob $Panel2SID$ ] ... | appendpipe [|loadjob $PanelZSID$] | outputcsv MyOutputFile.csv</query>
I tried your approach but faced an issue,
Appendpipe is merging the Results from all Panels horizontally, but I need to have the Results one on top of the other in the same Panel with the Panel Headers from the original Panels.
Cumulative Results Panel
Expecting to generate all of the above in the same CSV file.