Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
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!