How to link between two excel files in Qlikview ?

[Anonymous]

I have two excel files:

File A with columns :

Code | Product

And another file with columns:

Code| Code2

I am looking to get in Qlikview the following result :

Code|Product|Code2

How to link between two excel files in Qlikview ?

[YoussefBelloum · Accepted solution]

Hi,

you need to make a join between these two tables, like this:

FileA:

LOAD *

FROM FILEA;

JOIN

FileB:

LOAD *

FROM FILEB;

because in this case, Qlik will do a KEEP instead of a join, it will keep the tables joined but separate..

you should also think about which type of join you want to do, depending on the rows you want to keep,

rows of the left table? rows of the right table? Or both.

excellent post to understand all this:

Understanding Join, Keep and Concatenate

[ramasaisaksoft]

Hi Dede, 2 ways of options avilable to you

1. Code level
2. UI Level

Code Level:-

[Table A]:

Load

Code,

Product

From xxxxx.xlsx;

Join

Load

Code,

Code2

From xxxxx.xlsx;

by default Qlikview will follow Full Outer Join so it will create the table in Data Model Viewer ( Code|Product|Code2)

UI Level:-

[Table A]:

Load

Code,

Product

From xxxxx.xlsx;

[Table B]:

Load

Code,

Code2

From xxxxx.xlsx;

once you loaded the script automatically the association has been created between Table A & Table B on the Column Code

Qlikview Automatically follows the association between the tables when tables are having Same Column Name(Code in our example)

so if you observe the data model it will show 2 tables are joined with Code Column ,

you can create the Straight table with 3 Dimensions

Code | Product | Code2

[Hiran_Bandara]

I need create relationship between two files.please give advice to me