Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two tables:
83 Rows in one 85 in the other. Im trying to make a 3rd table that only shows those 2 rows diffing.
But the 2nd tables gets hundreds and hundreds of rows its like it get multiplied for every row.
i will attach my .Qvw and see if someone can hlep me.
I would also like to know what i'm doing wrong 😕
Thanks guys!
Meddelandet redigerades av: Niklas Söderqvist Uppdated .Qvw
Meddelandet redigerades av: Niklas Söderqvist updated qvw
Hi,
First off at the moment your two tables are not linked in the data model so by bringing 'row' in to your second table, you're creating a Cartesian join which is exactly what you say, every row is joining.
What fields are you looking to test?
None they are just from 2 different sources. I want to see the exact same amount of rows wiht same information in both.
And then in the 3rd table IF it doesnt match if one table has one more row than the other, then it should show only that row in the 3rd table.
Oh sorry didnt see that I used RowNo() in both tables I removed that linked one and added a EOD_RowNo and got my expected result.
Hi
Try loading the table second table using where not exists :
Table1:
Load
Key,
A,
B,
from abc.xls;
Table2:
Load
Key,
P
Q
from pqr.xls
where not exists(Key);
Drop Table Table1;
OK, so in your second table remove the column 'row' as this doesn't belong to this table.
You already have EOD.rowno() in there which is your row number.
Exactly working fine now! Thanks Now I need to make my where not exist work. Any ideas?
Ok so to get your third table then firstly I would rename EOD.rowno() something better, re-use your RowNo() as row so you get EOD.row
Then you could run this (might need some tweaking sorry written without testing):
table3:
LOAD *
resident EOD
where not exists (EOD.row,row);
Concatentate
LOAD *
resident marketplacedeals
where not exists (row,EOD.row);
This doesnt work field not found row
can you add your latest qvw and I will take a look