Problem with applymap

[kishorj1982]

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

[kishorj1982]

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