Removing applymap from where condition

[kishorj1982]

Hi All,

We are using applymap function in where condition in a script and below is the piece of example.

[Sales Order Purchased]:
LOAD DISTINCT [Sales Document Item Key] as [Sales Document Item Key Purchased]
FROM
[SalesOrderMapping.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;

But, whenever I am calculating apply map condition sales order mapping file and used the calculated field in where condition results are not matching.

Can you please suggest how to use precalculated apply map condition in where condition comparison.

Thanks

[kishorj1982]

Hello experts,

Can you please suggest on this

Thanks

[kishorj1982]

Hello All,

Can you please suggest on this. I need to remove those conditions from where clause but unfortunately after using the calculated column for apply map results are not matching.

Thanks.