Load Script: Using Lookup() in an If statement

[#1]

Hello,

I am wondering if it is possible to use Lookup() in an if statement. Below you can see an example:

Bron1:

LOAD Para1,

     Doel as A

FROM

TEST_QV.xlsx

(ooxml, embedded labels, table is C);

Fact:

LOAD Nr,

     Para1 AS P1,

     Art As Art1,

     If(Para1='B1',lookup('Doel','Para1',Para1,'Bron1'),'A')  AS Doel    

FROM

TEST_QV.xlsx

(ooxml, embedded labels, table is A);

See the attached file and the result.

[Gysbert_Wassenaar · Accepted solution]

It's certainly possible. However you renamed Doel to A in your first load, so the field Doel doesn't exist, but A does. Change your lookup accordingly.

[#3]

Thanks a lot

I was expecting that he would still look at the original name, but it works now! Sometimes you're almost there but just need a 2nd person to take out the last bug!