How to create single column of values from multiple column values in Qlik

[vish123]

Hi Team,

I have below requirement.

I have a table with 3 columns and one measure from which i need to create only one column with all 3 dimension values. How can i do it.

Table1:

column a,b,c , measure;

Output Table:

column a ,

measure ;

column a should contain all the values from b,c

Please suggest

[salonicdk28]

Hi,

Is this you are looking for-

Temp:
Load * inline [
Column_a,Column_b,Column_c,Amount

Hari123,teja954,pqr12,100

abcd123,xyz653,qwerty,200

mn342,acv11,dfgh14,300
];

Table:
Load Column_a as Column,
Amount
Resident Temp;

Concatenate(Table)
Load
Column_b as Column,
Amount
Resident Temp;

Concatenate(Table)
Load
Column_c as Column,
Amount
Resident Temp;
Drop Table Temp;

Output Table-

Thanks,

Saloni

[MarcoWedel]

Table1:
Crosstable (OriginalFieldName, a)
LOAD measure, a, b, c
From YourDataSource;

hope this helps

Marco

[vish123]

Hi Saloni,

Thanks for your reply. But if you observe Amount field values are getting duplicated. It should be same as original value.

[vish123]

Hi Marco,

Thanks for your reply.

Can you please elaborate this with one example if possible. That would be really helpful.

[MarcoWedel]

Please describe your expected result based on some sample data.

thanks