Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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:
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:
Hi Dede, 2 ways of options avilable to you
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
I need create relationship between two files.please give advice to me