Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am very new to Qlikview. I am facing the following problem in QlikView. The version I am using is Version: 9 SR3
I have 2 tables loaded from QVD.
1. Market Details
2. Revenue Details
Common Column Name for this two table is Carrier_No.
I need to find out what are the list of values (of Carrier_No) which are present in Revenue Details but not present in Market Details. After that I need to store the same in another QVD.
It will be very helpful you could please guide me to achieve the solution.
Thanks,
Amartya
Your code would look like this:
[AFTER YOU LOADED BOTH TABLES....]
noconcatenate
TEMP:
Load * resident RevenueDetails;
left join (RevenueDetails)
Load *, 1 as flag
resident MarketDetails;
noconcatenate
differences:
Load distinct Carrier_No resident TEMP where flag<>1;
drop table TEMP
store differences into differences.qvd;
drop table differnces;
Hi Erich,
Thanks for your reply. I was not able to follow your answer as I was supposed to meet smone sort of deadline. So, I implemented in my way.
During the load of data from QVD I outer joined 2 tables.
Revenue_Temp:
LOAD * FROM Revenue.qvd
outer join
LOAD * FROM Market.QVD
Undefined_Carrier:
LOAD Carrier_No RESIDENT Revenue_Temp
WHERE NOT EXISTS(Group_No); //Group_No is a clolumn from Market Table which is not there in Revenue Table.
Sorry for replying late. I will definitely check and mark your answer.
Thanks for your reply again,
Amartya