We have a number of mappings and apply map function wrt one table and these mappings used in a number of applications.
To reduce loading time I have created a centralise mapping file and used these calculated mappings in a different application.
But I found that the result is not matching.
Can you please suggest what could be the best way to avoid repetitive mapping calculation time for the number of applications.
Make sure you got distinct key values in your mapping table. If you do not have distinct key values you might get different result depending on which order you load the rows in your master table.
The first map table will not return the same values as the second.
MAPPING LOAD * [ MapKey, MapValue A, Ali B, Betty C, Cecil A, Anna B, Billy C, Conny ];
MyMapTable: MAPPING LOAD * [ MapKey, MapValue A, Anna B, Billy C, Conny
C, Cecil ];
In addition to the other statements a mapping-table could be (variously) sorted with an order by statement and your lookup value could be extended with an appropriate counter, like: value & '|' & counter-number and then an applymap() could grab the n-th value. But there are not many usecases in which such advanced approaches are really useful - therefore keep it simple and ensure that only distinct values are within your mappings.
I have created a mapping file for avoiding duplicate mappings from multiple applications.
I am creating transformed QVd for this and wherever mapping columns are required I am fetching these columns from created transformed QVd.
The purpose is to add all mappings related to SalesOrder.qvd to SalesOrderMappings.QVW file and use transformed
SalesOrderMappings.qvd file in all applications.
but looks like values does not match.
Can you please suggest where I need to test this application.
Thanks for your valuable inputs. We are using Qlikview 12 but I do not know. Anyway, I will make changes suggested by you.
If there is already where condition I am using and statement
[Handling Unit Creation Date Map]:
MAPPING LOAD [Sales Document Item Key],
Date (Min ([Handling Unit Creation Date])) as [Handling Unit Creation Date]
GROUP BY [Sales Document Item Key] and 1=1;
Please correct me if I am wrong