https://community.qlik.com/t5/QlikView/Matching-field-values-in-different-field-names/m-p/1524186#M748977 <P>Hello Team,</P><P>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?</P><P>For example</P><P><STRONG><EM>Input</EM></STRONG></P><TABLE><TBODY><TR><TD><STRONG>Level1</STRONG></TD><TD><STRONG>Level2</STRONG></TD><TD><STRONG>Level3</STRONG></TD></TR><TR><TD>Apple</TD><TD>Orange</TD><TD>Strawberry</TD></TR><TR><TD>Banana</TD><TD>Mango</TD><TD>Orange</TD></TR><TR><TD>Mango</TD><TD>Strawberry</TD><TD>Apple</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><STRONG><EM>Expected Output</EM></STRONG></P><TABLE><TBODY><TR><TD><STRONG>Common</STRONG></TD><TD><STRONG>Level1</STRONG></TD><TD><STRONG>Level2</STRONG></TD><TD><STRONG>Level3</STRONG></TD></TR><TR><TD>Apple</TD><TD>Yes</TD><TD>&nbsp;</TD><TD>Yes</TD></TR><TR><TD>Banana</TD><TD>Yes</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Mango</TD><TD>Yes</TD><TD>Yes</TD><TD>&nbsp;</TD></TR><TR><TD>Orange</TD><TD>&nbsp;</TD><TD>Yes</TD><TD>Yes</TD></TR><TR><TD>Strawberry</TD><TD>&nbsp;</TD><TD>Yes</TD><TD>Yes</TD></TR></TBODY></TABLE><P>&nbsp;</P> Sat, 16 Nov 2024 04:53:37 GMT haribabugv 2024-11-16T04:53:37Z https://community.qlik.com/t5/QlikView/Matching-field-values-in-different-field-names/m-p/1524186#M748977 <P>Hello Team,</P><P>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?</P><P>For example</P><P><STRONG><EM>Input</EM></STRONG></P><TABLE><TBODY><TR><TD><STRONG>Level1</STRONG></TD><TD><STRONG>Level2</STRONG></TD><TD><STRONG>Level3</STRONG></TD></TR><TR><TD>Apple</TD><TD>Orange</TD><TD>Strawberry</TD></TR><TR><TD>Banana</TD><TD>Mango</TD><TD>Orange</TD></TR><TR><TD>Mango</TD><TD>Strawberry</TD><TD>Apple</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><STRONG><EM>Expected Output</EM></STRONG></P><TABLE><TBODY><TR><TD><STRONG>Common</STRONG></TD><TD><STRONG>Level1</STRONG></TD><TD><STRONG>Level2</STRONG></TD><TD><STRONG>Level3</STRONG></TD></TR><TR><TD>Apple</TD><TD>Yes</TD><TD>&nbsp;</TD><TD>Yes</TD></TR><TR><TD>Banana</TD><TD>Yes</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Mango</TD><TD>Yes</TD><TD>Yes</TD><TD>&nbsp;</TD></TR><TR><TD>Orange</TD><TD>&nbsp;</TD><TD>Yes</TD><TD>Yes</TD></TR><TR><TD>Strawberry</TD><TD>&nbsp;</TD><TD>Yes</TD><TD>Yes</TD></TR></TBODY></TABLE><P>&nbsp;</P> Sat, 16 Nov 2024 04:53:37 GMT https://community.qlik.com/t5/QlikView/Matching-field-values-in-different-field-names/m-p/1524186#M748977 haribabugv 2024-11-16T04:53:37Z https://community.qlik.com/t5/QlikView/Matching-field-values-in-different-field-names/m-p/1524192#M748978 <P>Hi Haribabugv,</P><P>I think it's what you want:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Matching field values in different field names.PNG" style="width: 414px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/2646i8067C1688EEC26CB/image-size/large?v=v2&amp;px=999" role="button" title="Matching field values in different field names.PNG" alt="Matching field values in different field names.PNG" /></span></P><P>Thanks.</P><P>Aiolos Zhao</P> Thu, 27 Dec 2018 03:48:45 GMT https://community.qlik.com/t5/QlikView/Matching-field-values-in-different-field-names/m-p/1524192#M748978 uacg0009 2018-12-27T03:48:45Z