topic Re: Linking two tables (that are already linked) in QlikView

Linking two tables (that are already linked)

Wed, 13 Feb 2013 09:27:16 GMT

TLDR: I would like this join http://imgur.com/8zipK0v To be a left join, how to? See my script below. Directories removed for privacy.

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='£#,##0.00;-£#,##0.00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

SalesZip:

LOAD Zip,

Zip1,

Zip2,

ZipBoundary

FROM

LEFT JOIN (SalesZip)

Sales:

LOAD JDEDrID,

jdeaddressid,

LastName,

FirstName,

Channel,

AdvantageTier,

Address1,

Address2,

Address3,

Address4,

City AS SalesCity,

State AS StateSales,

PostalCode AS Zip,

Country AS SalesCountry,

[Total Advantage Shipments 2012],

[Advantage Shipments Per Location],

TMName,

RBMName,

DirName,

StateName AS StateNameSales,

StateBoundary AS StateBoundarySales

FROM

ZipTest:

LOAD Zip,

Zip1 AS Zip1Subs,

Zip2 AS Zip2Subs,

ZipBoundary AS ZipBoundarySubs

FROM

LEFT JOIN (ZipTest)

Subs:

LOAD Network,

[Account Name],

[Ship City] AS City,

[Ship State] AS State,

[Ship Zip] AS Zip,

County,

Market,

Country,

StateName,

StateBoundary,

latitude,

longitude

FROM

Re: Linking two tables (that are already linked)

Wed, 13 Feb 2013 09:37:04 GMT

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='£#,##0.00;-£#,##0.00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

SalesZip:

LOAD Zip,

Zip1,

Zip2,

ZipBoundary

FROM

LEFT JOIN (SalesZip)

Sales:

LOAD JDEDrID,

jdeaddressid,

LastName,

FirstName,

Channel,

AdvantageTier,

Address1,

Address2,

Address3,

Address4,

City AS SalesCity,

State AS StateSales,

PostalCode AS Zip,

Country AS SalesCountry,

[Total Advantage Shipments 2012],

[Advantage Shipments Per Location],

TMName,

RBMName,

DirName,

StateName AS StateNameSales,

StateBoundary AS StateBoundarySales

FROM

ZipTest:

LOAD Zip,

Zip1 AS Zip1Subs,

Zip2 AS Zip2Subs,

ZipBoundary AS ZipBoundarySubs

FROM

LEFT JOIN (ZipTest)

Subs:

LOAD Network,

[Account Name],

[Ship City] AS City,

[Ship State] AS State,

[Ship Zip] AS Zip,

County,

Market,

Country,

StateName,

StateBoundary,

latitude,

longitude

FROM

left join

load *

resident SalesZip;

drop table SalesZip;

Re: Linking two tables (that are already linked)

manideep78 — Wed, 13 Feb 2013 09:56:19 GMT

Hi,

Can you please put the requirement more clearer??