topic Doing different Lookups base on a condition from another table in QlikView https://community.qlik.com/t5/QlikView/Doing-different-Lookups-base-on-a-condition-from-another-table/m-p/1228352#M391713 <HTML><HEAD></HEAD><BODY><P>TableA:</P><P>LOAD A,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PRICE</P><P>FROM</P><P>somewhere</P><P></P><P></P><P>TableB:</P><P>LOAB B,</P><P>IF(LEN(A)='5', LOOKUP('PRICE', 'A', LEFT(B, 5), 'TableA',&nbsp;&nbsp; LOOKUP('PRICE', 'A', LEFT(B, 9), 'TableA')) AS NEW_PRICE</P><P>FROM</P><P>somewhere</P><P></P><P></P><P>How can I do 2 different lookups as shown in TableB base on the length of a field A in TableA? Any help appreciated!!!!</P></BODY></HTML> Fri, 17 Mar 2017 08:54:07 GMT 2017-03-17T08:54:07Z Doing different Lookups base on a condition from another table https://community.qlik.com/t5/QlikView/Doing-different-Lookups-base-on-a-condition-from-another-table/m-p/1228352#M391713 <HTML><HEAD></HEAD><BODY><P>TableA:</P><P>LOAD A,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PRICE</P><P>FROM</P><P>somewhere</P><P></P><P></P><P>TableB:</P><P>LOAB B,</P><P>IF(LEN(A)='5', LOOKUP('PRICE', 'A', LEFT(B, 5), 'TableA',&nbsp;&nbsp; LOOKUP('PRICE', 'A', LEFT(B, 9), 'TableA')) AS NEW_PRICE</P><P>FROM</P><P>somewhere</P><P></P><P></P><P>How can I do 2 different lookups as shown in TableB base on the length of a field A in TableA? Any help appreciated!!!!</P></BODY></HTML> Fri, 17 Mar 2017 08:54:07 GMT https://community.qlik.com/t5/QlikView/Doing-different-Lookups-base-on-a-condition-from-another-table/m-p/1228352#M391713 2017-03-17T08:54:07Z Re: Doing different Lookups base on a condition from another table https://community.qlik.com/t5/QlikView/Doing-different-Lookups-base-on-a-condition-from-another-table/m-p/1228353#M391714 <HTML><HEAD></HEAD><BODY><P>Would you be able to share some sample data and explain what the desired output is from that sample?</P></BODY></HTML> Fri, 17 Mar 2017 08:59:39 GMT https://community.qlik.com/t5/QlikView/Doing-different-Lookups-base-on-a-condition-from-another-table/m-p/1228353#M391714 sunny_talwar 2017-03-17T08:59:39Z Re: Doing different Lookups base on a condition from another table https://community.qlik.com/t5/QlikView/Doing-different-Lookups-base-on-a-condition-from-another-table/m-p/1228354#M391715 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Take a look at mapping tabels and ApplyMap in help.qlik.com</P></BODY></HTML> Fri, 17 Mar 2017 09:01:50 GMT https://community.qlik.com/t5/QlikView/Doing-different-Lookups-base-on-a-condition-from-another-table/m-p/1228354#M391715 2017-03-17T09:01:50Z