Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
Hi,
This inline works by using LOAD * from the table aswell?
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;
Yes you can use Inline table also but data with in the Qlikview file. What is your actual requirement.
Regards
Anand
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.
From DB and CSV, What was your expected output?
Final
Type, Size cost, qty
----
----
----
My expected output is just only the row that differences from either file. See below
Type, Size cost, qty
Trousers,M, 199, 10
This is what my first reply is giving... What is wrong with my reply? have you even tried?
did u tried manish solution? it's giving the same result whatever u expecting.
FYI,PFA.