Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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;
Hi Daniel,
Wow, really thanks for your help. It solved my problem.
Super thanks Daniel.
Regards.
Indra
it's good idea Daniel.
Ramya.