topic Re: store into export only unique rows in QlikView

store into export only unique rows

Tue, 03 Jun 2014 14:04:51 GMT

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.

Re: store into export only unique rows

marcus_sommer — Tue, 03 Jun 2014 14:12:20 GMT

You need distinct:

table:

Load DISTINCT * From xyz;

store table into table.csv;

- Marcus

Re: store into export only unique rows

Tue, 03 Jun 2014 14:57:22 GMT

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.

Re: store into export only unique rows

vardhancse — Tue, 03 Jun 2014 15:13:42 GMT

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

Re: store into export only unique rows

marcus_sommer — Tue, 03 Jun 2014 15:15:15 GMT

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

Re: store into export only unique rows

Tue, 03 Jun 2014 18:11:43 GMT

Yep that got it done. Thank you!!!