topic How to link between two excel files in Qlikview ? in QlikView

How to link between two excel files in Qlikview ?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 ?

Re: How to link between two excel files in Qlikview ?

YoussefBelloum — Tue, 20 Feb 2018 08:59:59 GMT

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

Re: How to link between two excel files in Qlikview ?

ramasaisaksoft — Tue, 20 Feb 2018 10:05:37 GMT

Hi Dede, 2 ways of options avilable to you

Code level
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

Re: How to link between two excel files in Qlikview ?

Hiran_Bandara — Sat, 24 Jun 2023 17:14:40 GMT

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