Straight Table into Crosstable via script

[#1]

Hello,

I have a straight table and I need a crosstable. It is possible to 'turn' a straight table into a crosstable via script?

Enclosed you will see an application, Table 1 is the start and as a result I need Table2.

There is a wizard for loading crosstables while turning them into straight table but how it is possible vice versa?

Thanks in advanced.

[vgutkovsky]

Why don't you just make it a pivot table? See attached. Or do you actually need it crosstabbed in the data?

[#3]

I actually store the data after loading/tranforming into a txt-file.

[vgutkovsky]

See this thread: http://community.qlik.com/thread/23968. You actually need the opposite of a crosstable. This can get a little tricky and, honestly, Excel handles it a lot better than QV so you might want to consider formatting the output elsewhere.

Regards,
Vlad

[Sokkorn]

Hi cplannerte,

Please check in my attahced file.

Let me know if you cannot open the file.

HTH

Regards,

Sokkorn Cheav

[#6]

Hi Sokkorn Cheav, I will try it, thank you.

I can't use Excel because of the amount of data, more than 1-2 million rows.

[Sokkorn]

Hi cplannerte,

Go ahear and let me know.

Regards,

Sokkorn Cheav