Discussion Board for collaboration on QlikView Scripting.
Good morning and good Monday everyone!
I need to find the differences (the different fields) between two tables.For example:
How can I do this?Maybe with OUTER JOIN?
Thanks in advance!
Go to Solution.
Try below code.
This will clear your idea.
Inclusion:Load id as Temp_ID FROM a;
Inner JoinLoad id as Temp_ID FROM b;
Exclusion:Load id,name FROM A Where not exists(Temp_ID,id);
ConcatenateLoad id,name FROM B Where not exists(Temp_ID,id);
Drop table Inclusion;
also run this code
load * inline [
load id as newid, name as newname
drop table TableA;
then output like this
But I'm finding a generic solution.
The tables mentioned are examples, but the fields are not fix.
I will use the script to find the differences between a txt result of reading each bar code from clothes from our provider and compare the fields with our reading.
Thank you very much Kaushik!
Thanks Kaushik. I was facing this problem until I've found your post.