Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
jaweher89
Contributor III
Contributor III

How to link between two excel files in Qlikview ?

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 ?

1 Solution

Accepted Solutions
YoussefBelloum
Champion
Champion

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

View solution in original post

2 Replies
YoussefBelloum
Champion
Champion

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

View solution in original post

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