Skip to main content
Announcements
Get Ready. A New Qlik Learning Experience is Coming February 17! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Join: Only see the difference between to files

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.

DB

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

10 Replies
MK_QSL
MVP
MVP

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;

Not applicable
Author

Hi,

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

MK_QSL
MVP
MVP

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;

its_anandrjs

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

Regards

Anand

Not applicable
Author

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.

Anil_Babu_Samineni

From DB and CSV, What was your expected output?

Final

Type, Size cost, qty

----

----

----

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Not applicable
Author

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

Type, Size cost, qty

Trousers,M, 199, 10

MK_QSL
MVP
MVP

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

buzzy996
Master II
Master II

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

FYI,PFA.