Comparision

[dhanavindhan]

Hi Everyone,

I have 2 tables

1. Dem -  Field(DWBLNO)

2. Cargo - Field(bl_no)

Common field between this 2 table is BLNO's.

I want to compare this 2 table blno's which are matching and non-matching. How to handle that in qlikview?

For example:

Dem table has - 10000 bl

Cargo table has - 8000 bl

I want to bring that non matching 2000 bl's.

Regards,

Dhana R

[YoussefBelloum]

Hi,

just rename the joining field in both tables by the same name using AS and you will have all the bl coming from each table

[dhanavindhan]

You are correct. I did that but Cartesian is happening while join and hangs my machine. Is there any possibilities just to see those 2000 bl's in separate table.

[YoussefBelloum]

you're maybe using a join, if you want to keep the table separate and see the 2000 bl on the Dem table, just rename the joining field in both table as the same name, Qlik will do a KEEP and it will keep the table separate

[Miguel_Angel_Baeyens]

With your own script, use EXISTS() like

Cargo:

LOAD *

FROM CargoSource;

Dem:

LOAD *

FROM DemSource

WHERE NOT EXISTS(BLNO);

DROP TABLE Cargo;

The resulting Dem table will be those lines in Dem where there is no matching BLNO.