Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
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