topic Re: How to create single column of values from multiple column values in Qlik in App Development

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

vish123 — Wed, 01 Dec 2021 14:44:48 GMT

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 — Wed, 01 Dec 2021 15:06:18 GMT

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 — Wed, 01 Dec 2021 21:46:03 GMT

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

hope this helps

Marco

vish123 — Mon, 06 Dec 2021 07:43:17 GMT

Hi Saloni,

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

vish123 — Mon, 06 Dec 2021 07:45:50 GMT

Hi Marco,

Thanks for your reply.

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

MarcoWedel — Mon, 06 Dec 2021 20:46:43 GMT

Please describe your expected result based on some sample data.

thanks