Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Outputting to Tabs in a CSV file

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

1 Reply
marcus_sommer

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