Need to make value of a table to column name

[santhosh_k_n]

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

[jsingh71]

Hi Santosh,

Please find attachment hope this will fulfill your need.

[er_mohit]

See the attached file

[maxgro]

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';