Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Is it possible to make a value in one of the column to make as column name.
for ex:
I am having two columns as shown below
Repot gen | name |
Gen1 | R1 |
Gen1 | R2 |
Gen1 | R3 |
Gen1 | R4 |
Gen1 | R5 |
Gen2 | R6 |
Gen2 | R7 |
Gen2 | R8 |
Gen2 | R9 |
Now i need to present above two columns as
Gen1 | Gen2 |
R1 | R6 |
R2 | R7 |
R3 | R8 |
R4 | R9 |
R5 |
Please suggest
Hi Santosh,
Please find attachment hope this will fulfill your need.
See the attached file
REPORT:
load *, if(peek(gen)<>gen, 1, 1+peek(id)) as id;
load * inline [
gen, name
Gen1, R1
Gen1, R2
Gen1, R3
Gen1, R4
Gen1, R5
Gen2, R6
Gen2, R7
Gen2, R8
Gen2, R9
];
TABLE:
load id, name as Gen1 Resident REPORT where gen='Gen1';
join (TABLE) load id, name as Gen2 Resident REPORT where gen='Gen2';