Joining Three table with different column name

[Anonymous]

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.

[swuehl]

What if you just rename the fields in table C that they match categoryID resp. ProductID?

[arpitkharkia]

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!

[qliksus]

What info does Category_mapping , Product_mapping in tablec  contain ?

[sasikanth]

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