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.
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?