Discussion Board for collaboration on QlikView Scripting.
The output that i want to obtain is the following: if the fieldA = 123 and if the fieldB = 01234, the record must show YES, instead NO. This Is a new fieldC.
FieldA Is in table3, fieldB in the table2, FieldC in table1.
Table1 and table2 have a Key field KeyA, table2 and table3 have a key field KeyB.
What Is the right expression?
Table1:load * inline [KeyA,column1,column2,123,test1,test2234,test3,test4];JOINTable2:load * inline [KeyB,KeyA,FieldBabc123,123,01234abc234,234,00000];
join(Table1)Table3:load * inline [KeyB,FieldAabc123,123abc234,234];
tempTable1:load *,if(FieldA='123' and FieldB='01234','YES','NO') as FieldCresident Table1;
drop table Table1;
View solution in original post