store into export only unique rows

[#1]

I was able to get my qlikview process to export a huge table for me as a .csv pulling only unique values once and I cannot for the life of me remember how I did it. What is the syntax or process to use store into and only export unique rows? I'm getting 1000s of duplicate values.

[marcus_sommer]

You need distinct:

table:

Load DISTINCT * From xyz;

store table into table.csv;

- Marcus

[#3]

I went ahead and added that logic. It does export, but the Script Execution Process never closes after, freezing Qlikview. I have to kill it from the Task Manager each time after it runs through the process. Very frustrating.

[vardhancse]

After loading the table.

Let vTest = Count(DISTINCT(Field))(path\'ABC.qvd');

Table:

Load * Inline

[

Name,Count

ABC,$(vTest)

];

STORE Table into Table.xls(txt);

[marcus_sommer · Accepted solution]

Perhaps it missed to drop the table and tried now to create a lot of keys ... try this:

table:

Load DISTINCT * From xyz;

store table into table.csv (txt);

drop tables table;

- Marcus

[#6]

Yep that got it done. Thank you!!!