Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
bharani8
Contributor III

with Concatenated field, am not able to perform lookup..

Hi Experts.. Need your quick input on my below query..

I have 2 tables in my script..

In the first table.. i have concatenated 2 fields as shown below

Table name - CSV_FILE:

     SO_ID,

     SO_LN_ITM_ID,

     SHIP_QT,

     SO_ID&SO_LN_ITM_ID as [CSV Concat],

In my 2nd Table.. i have done this..

Table name-India:

     SAPOrdNo,

      Itemno,

     SAPOrdNo & Itemno as [Fusion concat],

Now when i try to do a lookup to bring the corresponding Qty (SHIP_QT) from first table.. i end up getting an error saying "[Fusion concat] is not available"

Lookup('SHIP_QT','CSV_Concat',[Fusion concat],'CSV_FILE') as [Vlookup value]

Please help..

1 Solution

Accepted Solutions
Partner
Partner

Re: with Concatenated field, am not able to perform lookup..

Cool. I've had a look at this with some dummy data and it looks like LOOKUP() doesn't use the value you created when loading the table as it does not exist in the table you are reading FROM. So you need to use the formula you used to create [Fusion concat].

All you have to do to make this work is change:

Lookup('SHIP_QT','CSV_Concat',[Fusion concat],'CSV_FILE') as [Vlookup value]


to


Lookup('SHIP_QT', 'CSV_Concat', SAPOrdNo & Itemno, 'CSV_FILE') as [Vlookup value]

View solution in original post

4 Replies
Partner
Partner

Re: with Concatenated field, am not able to perform lookup..

The syntax look correct but in the Loopkup function, you are referencing 'CSV_Concat' but in the table, the field is called [CSV Concat].

Not sure if that's what's causing your issue.

bharani8
Contributor III

Re: with Concatenated field, am not able to perform lookup..

Hi McGowan - That was typo from my end.. it is same in my coding

Partner
Partner

Re: with Concatenated field, am not able to perform lookup..

Cool. I've had a look at this with some dummy data and it looks like LOOKUP() doesn't use the value you created when loading the table as it does not exist in the table you are reading FROM. So you need to use the formula you used to create [Fusion concat].

All you have to do to make this work is change:

Lookup('SHIP_QT','CSV_Concat',[Fusion concat],'CSV_FILE') as [Vlookup value]


to


Lookup('SHIP_QT', 'CSV_Concat', SAPOrdNo & Itemno, 'CSV_FILE') as [Vlookup value]

View solution in original post

bharani8
Contributor III

Re: with Concatenated field, am not able to perform lookup..

Thanks a ton McGowan!! U are an Star!!