topic Store current selections dataset to file in QlikView

Store current selections dataset to file

Mon, 24 Jan 2011 13:24:06 GMT

Hi, everyone.

I've get following issue: let's assume that my QV file contains only one table ("work_table"), I made some restrictions and want save rows of "work_table" which are matching current selections into a file.

How can I achieve this?

Best regards.

Store current selections dataset to file

Anonymous — Mon, 24 Jan 2011 13:31:54 GMT

Is an export not working for you?

Just right click on the obkject and choose export.

Store current selections dataset to file

Mon, 24 Jan 2011 15:05:25 GMT

No, "Export" will return only resulting dataset.

Even if I'll create a table box including all fields, I will miss duplicate rows (which exist in the source data): executing in the script following statement "STORE * from work_table into file.csv (txt); " produces file with 33k rows, but when execute command "Export" (with no restrictions) resulting file consists of only 8k rows.

So that is not a solution 😞

Store current selections dataset to file

rwunderlich — Tue, 25 Jan 2011 07:20:11 GMT

Add a row unique value to work_table in the script

recno() as Recno

and then add Recno to your table box.

-Rob

Store current selections dataset to file

Tue, 25 Jan 2011 10:25:18 GMT

Well this is not exactly what I need, because generated csv file should be used further by another application, so I have to propose to make changes there and this probably would be difficult.

But I agree that this approach is good for my issue.

Thank you, Rob.