Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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!
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
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?
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