Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Joining Three table with different column name

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.

4 Replies
Highlighted
MVP
MVP

Re: Joining Three table with different column name

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

Highlighted
Creator III
Creator III

Re: Joining Three table with different column name

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!

Highlighted
Specialist II
Specialist II

Re: Joining Three table with different column name

What info does Category_mapping , Product_mapping in tablec  contain ?

Highlighted
Specialist III
Specialist III

Re: Joining Three table with different column name

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