Key on CrossTable

[#1]

Hi,

I have a question, i have load data with CrossTable like this one :

Transform:

CrossTable(LEVEL , VALUE)

LOAD NAME,

     A,

     B,

     C,

     LEVEL&VALUE as key

FROM

......

I want to make LEVEL and VALUE field as a KEY for example LEVEL "A" and VALUE "1", so the KEY will be "A1". how can i make a key from crosstable field.

I really need your help.

Thanks, i really appreciate your help

Regards,

Indra

[danieloberbilli · Accepted solution]

Not sure if this is what you are looking for...but a possible approach:

Data:
LOAD * INLINE [
    NAME, A, B, C
    John, 50, 10, 23
    Richard, 10, 10, 25
    Sean, 20, 200, 22
];


Transform_tmp:
CrossTable(LEVEL , VALUE)
LOAD
     NAME,
     A,
     B,
     C
//     LEVEL&VALUE as key
Resident Data;

Transform:
LOAD
NAME,
LEVEL,
VALUE,
LEVEL &'_'& VALUE as key
Resident Transform_tmp;
DROP Table Transform_tmp;

[#3]

Hi Daniel,

Wow, really thanks for your help. It solved my problem.

Super thanks Daniel.

Regards.

Indra

[#4]

it's good idea Daniel.

Ramya.