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: 
chiso_chiso
Creator
Creator

Renaming fields in a crosstable

Gurus,

I used the attached sample to combine my headers which were in two rows of my excel sheet. Apparently, I need to rename some of my headers in both rows.

Can someone please guide.

1 Solution

Accepted Solutions
Anonymous
Not applicable

If you want to change the name of head1 , head 2 etc then you use

LOAD

head1 as NewHead1,

head2 as NewHead2

If you want to change the values Machinery, Metal etc I would recommend you to look into the ApplyMap-function.

Kind regards

Niklas

View solution in original post

7 Replies
jpenuliar
Partner - Specialist III
Partner - Specialist III

Hi,

Please see image, enter you new Label at the highlighted textboxpic 1.png

chiso_chiso
Creator
Creator
Author

Thanks Jonathan, is there a way of renaming each or individual columns that make up the head1 and head2?

jpenuliar
Partner - Specialist III
Partner - Specialist III

I was thinking, you could have done it at the LOAD SCRIPT in the first place to avoid renaming the Labels.

chiso_chiso
Creator
Creator
Author

Jonathan, would you kindly guide as an example, I keep getting errors. Thanks

Anonymous
Not applicable

If you want to change the name of head1 , head 2 etc then you use

LOAD

head1 as NewHead1,

head2 as NewHead2

If you want to change the values Machinery, Metal etc I would recommend you to look into the ApplyMap-function.

Kind regards

Niklas

jpenuliar
Partner - Specialist III
Partner - Specialist III

hmmm, in your script where you have

S1:

LOAD

     atr,

     if(Data='',Previous(Data),Data) as head1....

or

Left join(S1)

LOAD 

     atr,

     Data as head2...

you could just replace Head1/Head2 with the field Name you want.

jpenuliar
Partner - Specialist III
Partner - Specialist III

I Agree

Regards,

JP