Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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

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.

2 Replies
Highlighted
Partner
Partner

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

Work smarter, not harder
Highlighted
Specialist
Specialist

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