Renaming fields in a crosstable

[chiso_chiso]

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.

[jpenuliar]

Hi,

Please see image, enter you new Label at the highlighted textbox

[chiso_chiso]

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

[jpenuliar]

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

[chiso_chiso]

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

[Anonymous · Accepted solution]

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]

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]

I Agree

Regards,

JP