Discussion Board for collaboration on QlikView Layout & Visualizations.
I need help. I have 2 tables, that I load from SQL base (Table 1 and Table 2). I need to get in script Result Table 3. I need to add to Table 1 rows from Table 2 with values in Field A, that not include in Table 1. I prepare sample:
Go to Solution.
Please use the below code.
LOAD * INLINE [
Field A,Field B
] Where Not Exists([Field A]);
Hi Please use the below script.
This will works.
Please select Correct Answer instead of Helpful and close the thread. Thank you.
I think you not only want to Concatenate, but you need a WHERE NOT EXISTS to prevent loading where the field A value is in table 1.
WHERE NOT EXISTS([Field A]);
Your solution does not eliminate the values that already exist in Field A. Check again at the final results expectation. There is only 1 4 and 1 5 in the Field A. Need to include Where Not Exists
I need only one value 4 and 5 from Field A:
Thank you all
Please close the thread by selecting Correct Answer. Thank you.