topic dynamic mapping table in qlik sense desktop version in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/dynamic-mapping-table-in-qlik-sense-desktop-version/m-p/1390141#M3016 <HTML><HEAD></HEAD><BODY><P>@can we create dynamic mapping table in qlik sense desktop version? Scenario is created connection from DB A and from excel file B.</P><P></P><P>In A, project code and department are kept in single table&nbsp; C and mapping table with type(project/dept) is also there. In table D cost against project and department is there.</P><P></P><P>From excel file B mapping of department and project code is available but project code and department name in A is not in sync with B. For eg. Department "Global" in A is "Global Share" in B. Same is applicable for project code also.</P><P></P><P>Can we create a map&nbsp; table for this in BI tool where "Global" will be mapped with "Global Share"?&nbsp; Purpose is to find out department/project wise cost calculation If yes then how?</P></BODY></HTML> Wed, 29 Nov 2017 06:36:24 GMT Anonymous 2017-11-29T06:36:24Z dynamic mapping table in qlik sense desktop version https://community.qlik.com/t5/Connectivity-Data-Prep/dynamic-mapping-table-in-qlik-sense-desktop-version/m-p/1390141#M3016 <HTML><HEAD></HEAD><BODY><P>@can we create dynamic mapping table in qlik sense desktop version? Scenario is created connection from DB A and from excel file B.</P><P></P><P>In A, project code and department are kept in single table&nbsp; C and mapping table with type(project/dept) is also there. In table D cost against project and department is there.</P><P></P><P>From excel file B mapping of department and project code is available but project code and department name in A is not in sync with B. For eg. Department "Global" in A is "Global Share" in B. Same is applicable for project code also.</P><P></P><P>Can we create a map&nbsp; table for this in BI tool where "Global" will be mapped with "Global Share"?&nbsp; Purpose is to find out department/project wise cost calculation If yes then how?</P></BODY></HTML> Wed, 29 Nov 2017 06:36:24 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/dynamic-mapping-table-in-qlik-sense-desktop-version/m-p/1390141#M3016 Anonymous 2017-11-29T06:36:24Z