topic Loading Specific records from a table in QlikView

Loading Specific records from a table

Thu, 12 Mar 2015 15:27:47 GMT

Good afternoon

I have 2 tables that I want to load, one is a table of medical claims and one is a list of registered pharmacies, the common field is Pharmacy registration numbern which is assigned to each claims line in the claims file and is part of the record for each registered pharmacy. . I want to load all claims from the claims file for Pharmacies that are not registered, so do not have a record in the list of registered pharmacies. The fields in the claims file are - Registration number, date, amount charged, amount paid, member and the fields in the registered pharmacies list are - Registration number, Pharmacy name, State where Pharmacy resides. I won't to just load the records in the first table where the regustration number os not found int he second table.

Regards

Neil

Re: Loading Specific records from a table

MK_QSL — Thu, 12 Mar 2015 15:30:33 GMT

Claims:

Load *, [Pharmacy Registration Number] as TempPRN From ClaimsTable;

Pharmacies:

Load * From PharmaciesTable Where Not Exists(TempPRN ,[Pharmacy Registration Number]);

Drop Field TempPRN;

Re: Loading Specific records from a table

avinashelite — Thu, 12 Mar 2015 15:32:30 GMT

Hi,

Load the first table then use Exist function in the second table and load only needed data.

Table1:

LOAD * INLINE [

Num

];

Right Join

Table2:

LOAD * INLINE [

Num

] Where not Exists(Num);