Remove the header column when exporting the file

[has75042]

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:

[Vegar]

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

[has75042]

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".

[Vegar]

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