Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
swuehl
MVP
MVP

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

arpitkharkia
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!

qliksus
Specialist II
Specialist II

What info does Category_mapping , Product_mapping in tablec  contain ?

sasikanth
Master
Master

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