Dynamic filter in CPI-DS

[babruvahana]

Hi Experts,

I have a requirement in CPI-DS to fetch the customers from SAP whose names doesn't start with 'IC'.

For Ex:

0001123

ABCDEH

IC0124

IC0389

A24BNK

I have to skip the names IC0124 and IC0389 while fetching the customers.

If we make use of match_simple expression in mapping. We will have to change the mapping of all the other fields which is a tedious task.

Please let me know if there is any other way of achieving it or we can make of filter using.

Any leads will be highly appreciated as I am very new to CPI-DS.

Regards,

Pavan G

[former_member676983 · Accepted solution]

Hi Pavan,

You can achieve the results using Substring function and exclude the values using below function.

substr(columnname,1,2) != 'IC'

Hope this will resolve your question.

Thanks,

Pravi

[babruvahana · Accepted solution]

Hi pravi_sap

Thanks for the response.

Can I use this in the filter section instead of mapping? I have added other filters along with can I use it like below?

"/IBP/LOC_EXT".CUST_ATTR1='SOLD' AND "/IBP/LOC_EXT".CUST_ATTR3='C' AND substr("/IBP/LOC_EXT".LOCNO,1,2) != 'IC'

Regards,

Pavan G

[former_member676983]

You can use in filter condition and test the results