How to store csv data in cross table format

[Karim_Khan]

Hi Team,

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

Regards,

KK

[Anil_Babu_Samineni]

Try this?

Direct:

Generic Load * From Table;

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

[its_anandrjs]

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);

[Peter_Cammaert]

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...

[Karim_Khan]

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

[its_anandrjs]

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.