topic Re: Joining Three table with different column name in QlikView

Joining Three table with different column name

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Joining Three table with different column name

swuehl — Tue, 02 Jan 2018 10:08:09 GMT

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

Re: Joining Three table with different column name

arpitkharkia — Tue, 02 Jan 2018 10:16:50 GMT

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!

Re: Joining Three table with different column name

qliksus — Tue, 02 Jan 2018 10:16:59 GMT

What info does Category_mapping , Product_mapping in tablec contain ?

Re: Joining Three table with different column name

sasikanth — Tue, 02 Jan 2018 10:33:23 GMT

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