topic Re: Help with simple left join in QlikView

Help with simple left join

Wed, 25 Nov 2020 16:16:04 GMT

I have a qvd called accounts, with a NAME field.

I have another database table called customer_dim, which has a name field.

I want the final name table to only have the fields in the NAME from Accounts, and anything associated with those from Customer_dim.

The below isn't working, any ideas?

Thanks

here is the error

Re: Help with simple left join

Anil_Babu_Samineni — Tue, 27 Jun 2017 16:23:08 GMT

How your data model looks when you load simple join from 2 tables?

Re: Help with simple left join

Tue, 27 Jun 2017 16:24:58 GMT

I'm not sure what you mean by simple join

Re: Help with simple left join

Tue, 27 Jun 2017 16:25:47 GMT

by renaming both NAME and name fields to Customer, it just combines the two. I only want the fields in NAME

Re: Help with simple left join

Anil_Babu_Samineni — Tue, 27 Jun 2017 16:29:21 GMT

I think you just added error, Any how can you do that Left join for Accounts like below for Load statement

Left Join (Accounts)

Load * Resident Customers;

Re: Help with simple left join

sunny_talwar — Tue, 27 Jun 2017 16:31:29 GMT

May be check out Where Exists

Qlikview WHERE EXISTS by RFB 167 - YouTube

QlikView Maven: QlikView Exists Function

Re: Help with simple left join

Tue, 27 Jun 2017 16:34:21 GMT

I tried it, but my Customer table is still a combination of the two tables.

Re: Help with simple left join

Anil_Babu_Samineni — Tue, 27 Jun 2017 16:42:06 GMT

can you share the script rather than image on wall

Re: Help with simple left join

Tue, 27 Jun 2017 16:45:07 GMT

Accounts:

Load

ALPHA_PRODID as AlphaProdID,

NAME as Customer

From D:\BI Docs\QVD Generators\Accounts.qvd (qvd)

where DISPOSITION = 'Active'

and TYPE_OF_SITE = 'HQ'

and ACCOUNT_TYPE = 'Customer';

Customer:

Load

name as Customer,

customer_group,

customer_key;

SQL SELECT

customer,

"customer_group",

"customer_key",

name

FROM PUB."customer_dim";

Left Join (Accounts)

Load * Resident Customer

;

Re: Help with simple left join

Anil_Babu_Samineni — Tue, 27 Jun 2017 16:51:55 GMT

May be this is last question to you, Does this select and Load clauses are same fields?? Or typo error? Because, Load statement it showing like name is the field but SELECT statement showing customer? I am sorry if i ask irrelevant question

Re: Help with simple left join

Tue, 27 Jun 2017 16:54:18 GMT

No, the two customers are different.

Thanks for the help. I decided to just not load in one of the customer fields for now. Thanks.

Re: Help with simple left join

Anil_Babu_Samineni — Tue, 27 Jun 2017 16:56:51 GMT

haha, I still not understand the issue and your intention. Some how you got clear for that. Thanks for point out