topic Problem regarding join in QlikView

Problem regarding join

Mon, 13 Dec 2010 13:50:28 GMT

Hi all. I have a problem regarding shipping address and billing address in a table. The problem is: Table1: ShippingAddressID BillingAddressID Table2 AddressID How can i do that in the interface i have only AddressID that is mapped to both fields in Table1 ?

Problem regarding join

boorgura — Mon, 13 Dec 2010 15:02:13 GMT

You will have to replicate the field in Table 2.

AddressID as BillingAddressID,
AddressID as ShippingAddressID

Problem regarding join

Tue, 14 Dec 2010 09:38:30 GMT

Hi and thank you for your reply.

I have allready did that but the problem is that it creates a syntetic key.

Problem regarding join

boorgura — Wed, 15 Dec 2010 19:27:45 GMT

you can create a key using both the fields.

(may be by just concatenating them)

and then rename the individual fields differently in the 2 tables.

if all you want to do is get the syn key out.

But I believe the syn key should be doing the same thing for us implicitly.

Problem regarding join

Thu, 16 Dec 2010 09:14:38 GMT

Hi.

BillingAddress and ShippingAddress are not allways the same. I cant see how i can create a concatenated key from those fields because sometime

BillingAddress & ShippingAddress <> AddressID & AddressID.

Problem regarding join

Thu, 16 Dec 2010 09:49:26 GMT

Hello Christian,

if I got you right, you have in one table two times an address_id pointing to one (address-) table. I would load the address-table twice with different table names and qualified fieldnames(!) using code similar to:

BillingAddress: load . . . AddressID AS BillingAddressID; . . . City AS BillingCity; . . .

ShippingAddress: load . . . AddressID AS ShippingAddressID; . . . City AS ShippingCity;

Regards, Roland

Problem regarding join

Thu, 16 Dec 2010 12:33:36 GMT

Hi Roland.

Thank you for the solution. This solution removes the synthetic key.

Regards,

Cristian.

Problem regarding join

kaushalview — Thu, 16 Dec 2010 12:52:59 GMT

Hi,
Use this

AddressID AS BillingAddressID

AddressID AS ShippingAddressID