topic Data difference in two resident tables in QlikView

Data difference in two resident tables

Thu, 30 Jun 2011 15:00:51 GMT

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

Data difference in two resident tables

erichshiino — Fri, 01 Jul 2011 03:55:40 GMT

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;

Data difference in two resident tables

Tue, 05 Jul 2011 07:50:48 GMT

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