Discussion Board for collaboration on QlikView Scripting.
I am trying to pull non-matched records from below table1, & table2.
LOAD * INLINE [F1, F21, A5, E6, F];Table2:LOAD * INLINE [F1, F31, A3, C6, F];Non_Matched:LOADF1, F3 Resident Table2Where not Exists(Table1,F1);
But above script not producing any o/p, Can one of you let me Know how to compare table2 records with table1 and then pull only non-matched record of table2.
Go to Solution.
Possibly you could use something like this
LOAD * INLINE [
Where Not IsNull(F2);
Drop Table Table1Temp;
can you pls try this:
Right join LOAD * INLINE [
] where not Exists(F1);
Do you want your main tables to be present and the result table be another table?
Thanks for your response.
Yes i am looking Non_matched records on sperate table and also i wanted to keep orginal input tables as it is.
Please try the below script and let me know if you have any concerns/questions.
LOAD * INLINE [F1, F21, A5, E6, F]; Table2:LOAD * INLINE [F1 , F31, A3, C6, F];Table3:LOADF1 , F2 ,F1 as F4Resident Table1;joinLOADF1 , F3 Resident Table2;Non_Matched:LOADF1 as F4, F3 as F5Resident Table3Where not Exists(F4); Drop tables Table3;RENAME Field F4 to F1;
RENAME Field F5 to F3;
Thanks its worked.
Thanks this one also worked.
Actually you dont need to do an Outer Join for the result.
LOAD * INLINE [F1, F21, A5, E6, F];Table2:LOAD * INLINE [F11, F31, A3, C6, F];Non_Matched:
NOCONCATENATELOADF1, F3 Resident Table2Where not Exists(F11,F1);
DROP TABLE Table2;
This will also work.
Hi Vivek, Thanks for your suggestion.
Can you attach your app, I tried above code and it did not work for me where it is not producing any records in Non_matching table.
Please find the attached file.