Two tables, rows gets multiplied in the 2nd table

[#1]

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

[#2]

Updated Qvw in my post now thanks so much!

[adamdavi3s]

Struggling to figure this one out!

Can't make it work with your tables, but if I add the Qlik example it works fine!

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/InterRecordFunctions/E...

[adamdavi3s]

Ok only thing I can suggest trying is to remove the qualification and rename the fields appropriately manually, e.g. eod_row

AFAIK this should work so the table qualification is the only thing I can think it might not like!

table3:

LOAD *

resident EOD

where not Exists (EOD.row, row);

Concatenate

LOAD *

resident marketplacedeals

where not Exists (row, EOD.row);

[#5]

still doesnt work says field not found

[#6]

Do you have any idea how to make a key and compare that key to the other table?

If I can look at: eod_SD&eod_Symbol&eod_Side&eod_Price

And compare those fields to the other table it should work. Just cant get the synbtax right :S

[#7]

I haev created a key now with the uniquely identiying fields, but it gives me error if I use where not exists in the other table.

[adamdavi3s]

You shouldn't need the key though as row and EOD.row are your key fields in theory.

Something weird here, I am missing the way that exists should work.... I don't quite get why the help example works but your data does not.

[#9]

Could it be that I have 3 tables so to speak not joined into 1 full table?

[adamdavi3s]

Have you got a new qvw where you have taken the 'qualify' off?

I just tried this again with the help example and it does NOT work when qualify is used

[#11]

I have removed the qualify yes. see my latest qvw in original post.

But it is not working.press ctrl+t youll see the tablestructure.