@can we create dynamic mapping table in qlik sense desktop version? Scenario is created connection from DB A and from excel file B.
In A, project code and department are kept in single table C and mapping table with type(project/dept) is also there. In table D cost against project and department is there.
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.
Can we create a map table for this in BI tool where "Global" will be mapped with "Global Share"? Purpose is to find out department/project wise cost calculation If yes then how?