Storing Data into Multiple Tabs in an Excel / CSV file.
I was wondering if there was a way to store tables in to Excel or CSV into multiple tabs in QlikSense. This could be achieved in the Qlikview with Macros but as you know QlikSense does not supprort macros. Is there anyway i could store in the load script. Thanks in Advance.
Re: Storing Data into Multiple Tabs in an Excel / CSV file.
You can have an external PowerShell to do the job for you - collecting multiple xlsx-files into one. The PowerShell script could be triggered by the creation of the files and then perform post-processing of them into a single file. You can use the built-in Window FileSystemWatcher event triggering mechanism.