Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

store into export only unique rows

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.

1 Solution

Accepted Solutions
marcus_sommer

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

View solution in original post

5 Replies
marcus_sommer

You need distinct:

table:

Load DISTINCT * From xyz;

store table into table.csv;

- Marcus

Not applicable
Author

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
Specialist III
Specialist III

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

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

Not applicable
Author

Yep that got it done. Thank you!!!