Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
haribabugv
Creator
Creator

Matching field values in different field names

Hello Team,

I am trying to concatenate different field names and then find the matching values. I tried using vlookup but i was not successful. Can someone help me out to arrive at the expected output?

For example

Input

Level1Level2Level3
AppleOrangeStrawberry
BananaMangoOrange
MangoStrawberryApple

 

Expected Output

CommonLevel1Level2Level3
AppleYes Yes
BananaYes  
MangoYesYes 
Orange YesYes
Strawberry YesYes

 

Labels (1)
1 Solution

Accepted Solutions
uacg0009
Partner - Specialist
Partner - Specialist

Hi Haribabugv,

I think it's what you want:

Matching field values in different field names.PNG

Thanks.

Aiolos Zhao

View solution in original post

1 Reply
uacg0009
Partner - Specialist
Partner - Specialist

Hi Haribabugv,

I think it's what you want:

Matching field values in different field names.PNG

Thanks.

Aiolos Zhao