Doing different Lookups base on a condition from another table

[#1]

TableA:

LOAD A,

           PRICE

FROM

somewhere

TableB:

LOAB B,

IF(LEN(A)='5', LOOKUP('PRICE', 'A', LEFT(B, 5), 'TableA',   LOOKUP('PRICE', 'A', LEFT(B, 9), 'TableA')) AS NEW_PRICE

FROM

somewhere

How can I do 2 different lookups as shown in TableB base on the length of a field A in TableA? Any help appreciated!!!!

[sunny_talwar]

Would you be able to share some sample data and explain what the desired output is from that sample?

[#3]

Hi

Take a look at mapping tabels and ApplyMap in help.qlik.com