Join two tables with different name key

[#1]

Hello



I have two tables, for example, the Customer table and the table Customer2, the Customer table as the key to the fields CLIENT, and the table Customer2

as the key to the fields NOCLIENT.



How to link these two tables?



thank you



Maurice

[SunilChauhan]

check weither data of two filels are looking similar

if so the rename as same name

it will provide you solution

[erichshiino]

Hi, Maurice.

I'm not sure if I understood your question, but you need to rename the fiels to create a link in QlikView.

For example:

1)

Customer:

Load Client, Phone, Email

From ....

Customer2

Load NOCLIENT as Client

Address, Rating

From...

or

2 )

Customer:

Load Client, Phone, Email

From ....

left join(Customer)

Load NOCLIENT as Client,

Address, Rating

From...

Hope this helps,

Erich