Hello,
I would like to understand, e.g., how to script this excel logic into Qlik sense script:
=IF([@Task]="abc";"def";vlookup([@disc];GENERAL_Disc[#All];GENERAL_Disc!B$1;FALSE));"")
I have been lookin to functions like 'mapping load' and but i am struggling to find the proper way to add complex calculated fields (using columns from different tables) to the existing table structure.
Can someone help me solve the example and maybe suggest some best practice for these kind of issues?
The goal is to bring the 'computational weight' in cloud so that the data workflow would benefit.
Any help would be much appreciated, thanks!