Renaming fields of data in Crosstable

[chiso_chiso]

Gurus,

Kindly advise if it is possible to rename Data fields in a crosstable.

I have two rows of headers that are making up the data for my crosstable. I want to rename the fields in one of the rows that is making up the header.

Please assist

[Gysbert_Wassenaar · Accepted solution]

Yes, use a preceding load to change the field name:

Example:

Crosstable(K,V)

LOAD A, B as Q, C as R, D, E, F;

LOAD * INLINE [

A, B, C, D, E, F

X, 1, 2, 3, 4, 5

Y, 9, 8, 7, 6, 5

]

;

[chiso_chiso]

Thanks Gysbert..!

[chiso_chiso]

Hi there, I am trying to rename some healders in my 2nd row of headers but not successful. could you please guide with an example?

[Gysbert_Wassenaar]

What do you mean by 2nd row of headers? When data is loaded from a source table there can only be one row with field names.