topic Re: How to store csv data in cross table format in QlikView

How to store csv data in cross table format

Karim_Khan — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

Is this possible to store (xls,csv) data into cross table view?

Regards,

Re: How to store csv data in cross table format

Anil_Babu_Samineni — Thu, 12 Oct 2017 14:20:42 GMT

Try this?

Direct:

Generic Load * From Table;

Store Direct into Path\Sample.xls...;

Re: How to store csv data in cross table format

its_anandrjs — Thu, 12 Oct 2017 14:21:07 GMT

Seems no can you share any sample for that to look around for this. You can store csv table format as a csv file extension by store command

Store TableName into TableName.csv(txt);

Re: How to store csv data in cross table format

Peter_Cammaert — Thu, 12 Oct 2017 14:33:23 GMT

You can also manually export any Pivot table using RightMouseButtonMenu->Export... and selecting one of three available text formats. A pivot table will translate one-to-one into matrix layout thjat you can load with CROSSTABLE LOAD on condition that the pivot table has at least one horizontal dimension (for example Month or Year)

You can do the same in your Load script but that's quite a lot of work. The STORE statement will only export what is already present in a named internal table, so you will have to create a pivot table look-alike using some advanced script programming...

Re: How to store csv data in cross table format

Karim_Khan — Thu, 12 Oct 2017 14:45:11 GMT

I am creating dump and need to implement it at script table.

Re: How to store csv data in cross table format

its_anandrjs — Thu, 12 Oct 2017 14:49:37 GMT

You can try this also by using the Macro and export the file into csv formt. YOu can search about the macro code on the community.