topic Remove the header column when exporting the file in QlikView

Remove the header column when exporting the file

has75042 — Wed, 25 Nov 2020 16:16:04 GMT

Hey Community,

I need some desperate help. Is there a way to remove the header column when exporting to .csv file.

Current Result

Desire Result:

Re: Remove the header column when exporting the file

Vegar — Sat, 06 Apr 2019 21:28:18 GMT

You can do it, either by creating a VB or Javascript macro in QlikView or by making QlikView believe that the values of the first row of days is the header row.

Try searching the community or Google for examples on how it's done.

Good luck

Vegar

Re: Remove the header column when exporting the file

has75042 — Mon, 08 Apr 2019 19:52:00 GMT

I tried searching and I can't find anything. Can you please give me a example of "by making QlikView believe that the values of the first row of days is the header row".

Re: Remove the header column when exporting the file

Vegar — Mon, 08 Apr 2019 20:18:17 GMT

In my example I have an two column qvd-file with two columns, id and value. You can expand this solution by adding a new variable per extra column.

NewHeader:
LOAD 
  id, 
  value
from 
  Data.qvd (qvd)
WHERE 
  RecNo()=1;
LET vIdCol=peek('id', -1, 'NewHeader'); //to replace the id column header
LET IdValCol=peek('value', -1, 'NewHeader'); ////to replace the value column header
DROP TABLE NewHeader;

Data:
LOAD
  id as [$(vIdCol)],
  value as [$(IdValCol)]
from Data.qvd (qvd)
WHERE RecNo()>1
;

store Data into Data.csv (txt);