Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to change column headers to excel column headers?

Hi,

I want to change my column headers to Excel column headers (A, B, C, D)

For example:

CompanyNameDateSales
Today01/01/20162500
Tomorrow
01/01/2017
33000
Yesterday
01/01/2018
12354

Now i want this:

ABC
Today
01/01/2016
2500
Tomorrow
01/01/2017
33000
Yesterday
01/01/2018
12354

Does somebody know how I can achieve this?

Thans.

9 Replies
sunny_talwar

I guess these two settings are the important ones

Label should be set to None and I would expect that you have labels and wouldn't want to load them as data, so use header size -> line and 1 as the number

Capture.PNG

Not applicable
Author

I think I didn't asked my question correctly.

error.png

So know I want, instead of the dates as column headers, the real excel headers

So i want to get as header: "Resultaat, Leningnaam, AT, AU, AV, AW,...

Thanks

sunny_talwar

Is this for QlikSense?

Not applicable
Author

Yes this is for Qlik Sense

sunny_talwar

May be Reddys310‌ can guide you better with Qlik Sense

Not applicable
Author

error2.png

Do you maybe know how i know can get the value of the %Date (@3, @4) but I don't want to change the @3, @4 because the next time I read another Excel file with the same lay-out I don't want to get errors so I can't use the real date value because in each Excel file the date values will change.

simondachstr
Luminary Alumni
Luminary Alumni

Have a look at the Crosstable & Generic load functionality.

Not applicable
Author

I'm using a crosstable already, I've know idea how I can use the Generic load in this situation

reddy-s
Master II
Master II

Hi Matei,

sunindia‌ reply is the way to go, if you can generate the script the way sunny has mentioned in Qlikview and then copy the script across to Qliksense and that should work.

Thanks,

Sangram.