topic Re: i want to change one record from one column to another column in QlikView

i want to change one record from one column to another column

manoj217 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all , any one please help me on below requirement, your help is greatly appreciated.

id value may have more duplicate values it need to add the new columns like HD1,2,3,4--etc and below want to show their respected values on it.

i want to show this data in a straight table

Re: i want to change one record from one column to another column

Gysbert_Wassenaar — Wed, 30 Jan 2019 17:59:09 GMT

Don't change your data model. Use a pivot table object in the front end to show the data in this way.

Re: i want to change one record from one column to another column

manoj217 — Thu, 31 Jan 2019 06:04:04 GMT

Hi,
Thanks for your reply.
I have tried pivot table it will change values to column names in pivot, I don't want in that manner.
I want if I have more records for the same value in another column that I want to show in a different column. But the duplicates are dynamic