Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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.
Thanks
Hi,
I am using apply map in where the condition as per below.
[Sales Order Purchased]:
LOAD DISTINCT [Sales Document Item Key] as [Sales Document Item Key Purchased]
FROM
[SalesOrder.qvd]
(qvd)
WHERE Match ([%Sales doc. type_DOC_TYPE], 'ZQT', 'ZQH') = 0
AND Exists ([Sales Document Item Key]) //AND NOT Exists ([%Sales Document TECO Complete Item], [Sales Document Item Key])
AND ApplyMap ('PO Material Map', [Sales Document Item Key], 'N/A') = %Material_MATERIAL;
If I can use the calculated column instead of ApplyMap ('PO Material Map', [Sales Document Item Key], 'N/A') the result does not match.
Please suggest.
Thanks