topic Re: Store Into txt file with specific sort order in QlikView

Store Into txt file with specific sort order

gerhardl — Wed, 18 Dec 2013 12:35:08 GMT

Hi,

If I load from multiple text files and then store that table into one text file, can I choose the sort order of the new txt file?

TEST_TABLE"

LOAD

Field 1,

Field 2,

Field 3

FROM [Path.txt]

(txt, codepage is 1252, embedded labels, delimiter is '~', msq);

STORE 'TEST_TABLE' into [TEST_TABLE.txt] (txt, codepage is 1252, embedded labels, delimiter is '~', msq);

In my TEST_TABLE.txt file I want to sort by Field 3 alphabetically for instance.

Wed, 18 Dec 2013 13:15:53 GMT

Hi,

what about loading temporary table with ORDER BY Field 3 before using STORE statement?

Gysbert_Wassenaar — Wed, 18 Dec 2013 13:20:42 GMT

TEMP_TEST_TABLE:

LOAD

[Field 1],

[Field 2],

[Field 3]

FROM [Path.txt]

(txt, codepage is 1252, embedded labels, delimiter is '~', msq);

TEST_TABLE:

NOCONCATENATE

LOAD * RESIDENT TEMP_TEST_TABLE ORDER BY [Field 3];

STORE 'TEST_TABLE' into [TEST_TABLE.txt] (txt, codepage is 1252, embedded labels, delimiter is '~', msq);