Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using QlikSense to export information from SAP BW into CSV files.
I would like to be able to run multiple queries in one script and push the output into separate tabs on the same CSV workbook.
Any ideas how I would achieve this please?
This is what I have so far (this comes after my load and select etc.):
STORE * FROM DataSource INTO [lib://Master Data/TESTData.csv] (txt);
which outputs to a single sheet. What amendment do I need to make to specify a tab to output to?
Thanks in advance!
Scott
A csv is a text-file and doesn't have tabs. You could (in general but in Qlik not in a easy way) only append data on the end of the file but it's only complicated without any added-value - so the best option is to store each table within an own file.
- Marcus