Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
Can I join three different table having different column name?
I know if i have same column name then Qlikview automatically joins them. But my requirement is bit different.
senario -
Table A - this table contains aggregated data based on categoryID. columns ( categoryID,categoryName,Sales,TotalCount)
Table B - This table contains Product Information like - ProductID,ProductPrice,ProductSize.
Table C - This Tabls Contains mapping information with two column categoryID_Mapping and ProductID_Mapping
I am modifying existing application which has Table A present and written complex macros on this. I need to display product level information including aggregated data. Is there any way to join this three table?
Thanks in advance.
What if you just rename the fields in table C that they match categoryID resp. ProductID?
Hi,
You can use alias here. Better change the name of the columns in Table B and Table C to that of the fields present in Table A.
Example -
ProductID as ProductID_mapping
and
categoryID_Mapping as categoryID
Thanks!
What info does Category_mapping , Product_mapping in tablec contain ?
HI Sagar,
I don`t think it is correct to Join Table B with A ( as per the mentioned Fields) .
You wont get product level sales breakdown if you Join these two tables based on CATEGORY ID which is higher level than Product ID.
Ex output:
Prod ID , CatID,Sales
A1,Mobiles,100
B1,Mobiles,100
C1,Mobiles,100
sales values will be repeated for every product under that category. check once