Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am learning Qlikview and I have a basic doubt abot Join.
I have two tables which are 20 columns in common. I want to make join for this two tables.
In database it is inner join between two tables. If I want to achieve the same should I use Inner Join between two tables. Or simply
like
Load * from table1;
load * from table2;
Regards,
Kumar
If I comment same columns in one of the table is also fine.
Yes, it should be.
Table1:
LOAD AutoNumber(Field1&'|'&Field2&'|'&Field3.....) as Key
Field1
Field2
Inner Join (Table1)
LOAD AutoNumber(Field1&'|'&Field2&'|'&Field3.....) as Key
After commenting common columns fields except one key field, is it required to concatenate common columns Sunny?
Qlikview will perform Join like in database sql queries. The other option in Qlikview is Concatenate and it works like UNION in SQL.
Based on your requirement you can use Join or concatenate. Before take which operation need to perform, you need to understand the tables relation with respect to your business. If two tables have fact then you can simply concatenate. One table is Fact & other table is Dimension table I would recommend Join.