Qlik Sense - Storing into a CSV file without the header data

[roisolberg]

Hi All,

I am exporting a report into a CSV file using Qlik Sense and i am trying to remove the column headers from the file and keep only the data stored.

my store command : Store DailyReport into "lib://CSV/SHP[$(Company)]_$(vDateS)_$(vTimeS)_F.csv"(txt, delimiter is '|');

i've tried searching in past discussions but i could'nt find a matching solution.

If anyone has any experience on the matter i'd much appreciate,

Thanks in advance!

[roisolberg]

Thanks again for your help

this report is dynamic and changes daily.

it seems their might be NULL's and sometime in the 1st record, is there any way to pass that?

Thanks!

[marcus_sommer]

You could within an additionally step check the records within a flag and sort them afterwards maybe with something like this:

...

-(rangecount(Serial, Box_ID, ...)=5) as Flag

...

SerialOutDailyReportSOURCE:

load ...

resident ...

order by Flag desc;

- Marcus

[roisolberg]

Hi Marcus,

I am not quite sure where should i put the rangecount

also, it seems as this function is not supported by qlik sense, could it be?

[marcus_sommer]

It just means to integrate this flag-field within the first load of these table and within a following load you could sort the data with it. The help to rangecount could you find here: https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/ChartFunctions/RangeFunctions/ran...

- Marcus