Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
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

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

Highlighted
Creator III
Creator III

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

What info does Category_mapping , Product_mapping in tablec  contain ?

Highlighted
Specialist III
Specialist III

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