topic Joining two tables in QlikView

Joining two tables

Mon, 26 Oct 2015 14:06:01 GMT

T_BDE_DAILY:

NoConcatenate
LOAD [Loan Number],
[Fips County Code]

RESIDENT
T_BDE_DAILY_tmp

drop table T_BDE_DAILY_tmp;

T_County_Temp:
LOAD
county_fips,
county as CountyName

FROM $(base_path)Mortgage\Data\Text\lm_county_list.txt(txt, codepage is 1252, embedded labels, delimiter is '', msq)
where county_fips >000

Produces 2 tables

T_BDE_DAILY

T_County_Temp

I need to left join T_County_Temp to T_BDE_Daily. I need to keep T_BDE_Daily and drop T_County_Temp

Re: Joining two tables

Gysbert_Wassenaar — Mon, 26 Oct 2015 14:31:42 GMT

If county_fips contains the same values as [Fips County Code] then try:

T_BDE_DAILY:

NoConcatenate
LOAD[Loan Number],
[Fips County Code]

RESIDENT
T_BDE_DAILY_tmp

drop table T_BDE_DAILY_tmp;

LEFT JOIN(T_BDE_DAILY)

LOAD
county_fips as [Fips County Code],
county as CountyName
FROM $(base_path)Mortgage\Data\Text\lm_county_list.txt

(txt, codepage is 1252, embeddedlabels, delimiter is '', msq)
where county_fips >000

Or even better don't join at all:

MapCountry:

mapping LOAD
county_fips as [Fips County Code],
county as CountyName
FROM $(base_path)Mortgage\Data\Text\lm_county_list.txt

(txt, codepage is 1252, embeddedlabels, delimiter is '', msq)
where county_fips >000

T_BDE_DAILY:

NoConcatenate
LOAD[Loan Number],
[Fips County Code],

ApplyMap('MapCounty',[Fips County Code]) as CountyName

RESIDENT
T_BDE_DAILY_tmp;

drop table T_BDE_DAILY_tmp;

Re: Joining two tables

tamilarasu — Mon, 26 Oct 2015 14:37:20 GMT

You need a common key field between two tables..

Load A1,

From

Source1;

left join(A)

Load B1,

From

source2;

if your key field is not same then type like fieldname as B1.. hope this helps you..