topic Re: Join: Only see the difference between to files in QlikView

Join: Only see the difference between to files

Wed, 25 Nov 2020 16:16:04 GMT

Hi folks,

Can anyone help me with his one:

I got on one hand our database and then a client send us a csv file. All good I can make joins on fields and get everything to work.

BUT I would also need to see by this join that I made IF one file contains any other rows. So in the case below the only row I want to see in a table is the Trousers one. So that I can easy contact the client regarding these trousers.

Type, Size cost, qty

Jeans, L, 32, 1

Shirt, L, 23, 2

Trousers,M, 199, 10

CSV

Type, Size cost, qty

Jeans, L, 32, 1

Shirt, L, 23, 2

Re: Join: Only see the difference between to files

MK_QSL — Wed, 23 Nov 2016 09:39:26 GMT

CSV:
Load *, Type&Size&cost as Key  Inline
[
  Type, Size, cost, qty
  Jeans, L, 32, 1
  Shirt, L, 23, 2
];


NoConcatenate
DB:
Load * Inline
[
  Type, Size, cost, qty
  Jeans, L, 32, 1
  Shirt, L, 23, 2
  Trousers, M, 199, 10
]Where Not Exists(Key, Type&Size&cost);


Drop Table CSV;

Re: Join: Only see the difference between to files

Wed, 23 Nov 2016 09:42:42 GMT

Hi,

This inline works by using LOAD * from the table aswell?

Re: Join: Only see the difference between to files

MK_QSL — Wed, 23 Nov 2016 09:54:36 GMT

CSV:

Load

Type&Size&cost as Key

From yourCSVfile;

NoConcatenate

DB:

Load

Type,

Size,

cost,

qty

From your DB

Where Not Exists(Key, Type&Size&cost)

;

Drop Table CSV;

Re: Join: Only see the difference between to files

its_anandrjs — Wed, 23 Nov 2016 11:46:27 GMT

Yes you can use Inline table also but data with in the Qlikview file. What is your actual requirement.

Regards

Anand

Re: Join: Only see the difference between to files

Thu, 24 Nov 2016 07:47:28 GMT

My requirement is that I have 2 files, 1 is mine 2nd one is the clients. Then I only want to see the difference between those two files.

Re: Join: Only see the difference between to files

Anil_Babu_Samineni — Thu, 24 Nov 2016 07:55:45 GMT

From DB and CSV, What was your expected output?

Final

Type, Size cost, qty

----

Re: Join: Only see the difference between to files

Thu, 24 Nov 2016 09:56:48 GMT

My expected output is just only the row that differences from either file. See below

Type, Size cost, qty

Trousers,M, 199, 10

Re: Join: Only see the difference between to files

MK_QSL — Thu, 24 Nov 2016 09:58:01 GMT

This is what my first reply is giving... What is wrong with my reply? have you even tried?

Re: Join: Only see the difference between to files

buzzy996 — Thu, 24 Nov 2016 10:11:42 GMT

did u tried manish solution? it's giving the same result whatever u expecting.

FYI,PFA.

Re: Join: Only see the difference between to files

Thu, 24 Nov 2016 10:57:41 GMT

Im sure it does cant seem to understand load inline tough:/ I provided my app in original post. Can you have a look please?