topic Re: Comparision in QlikView

Comparision

dhanavindhan — Fri, 08 Jun 2018 07:37:44 GMT

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

Re: Comparision

YoussefBelloum — Fri, 08 Jun 2018 07:42:39 GMT

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

Re: Comparision

dhanavindhan — Fri, 08 Jun 2018 07:47:20 GMT

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.

Re: Comparision

YoussefBelloum — Fri, 08 Jun 2018 08:06:47 GMT

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

Re: Comparision

Miguel_Angel_Baeyens — Fri, 08 Jun 2018 08:11:22 GMT

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.