Discussion Board for collaboration related to QlikView App Development.
I have two excel files:
File A with columns :
Code | Product
And another file with columns:
I am looking to get in Qlikview the following result :
How to link between two excel files in Qlikview ?
you need to make a join between these two tables, like this:
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
Hi Dede, 2 ways of options avilable to you
by default Qlikview will follow Full Outer Join so it will create the table in Data Model Viewer ( Code|Product|Code2)
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