Find distinct values from multiple columns and display the values a columns in the result table

[malpranati]

I have a table as follows:

DR          Field1       Field2        Field3        Field4

1              A                C                    C                 D

2             B                 A                    D                 B

3             Y                 G                     A                 N

I require the output as follows:

DR        A        B       C        D         G      N      Y

1

2

3

How do I proceed? Please do help me with any ideas if you have.

[JordyWegman]

Hi,

Follow these steps:

1. Do a cross table load on your first table. If you don't know how to, see this link
2. Load the column as distinct and make a dimension
3. Map or join this were you want it
4. Load the dimension in

Jordy

Climber

[Shubham_Deshmukh]

Hi @malpranati ,

Just check out this link, it might be helpful to you,

https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470

Rgrds.

Shubham