Ignoring records from S4->CPI-DS->IBP? To be done in CPI-DS or IBP postprocessing?

[FarooqAhmed]

Hi CPI-DS/IBP Team.

We have a data extraction being done from S4 to IBP through CPI-DS.

How to ignore the records with keyfiguredate from S4->CPI-DS->IBP? To be done in CPI-DS or IBP postprocessing?

Also let me know how to do the viceversa like considering only records which has specific date?

Please suggest the best practice in CPI-DS/IBP which can filter from S4 extractor.

Thank You.

Regards,

FA

[balazsbence95]

Hi,

If you do not want certain columns/attributes loaded to IBP, simply skip mapping those columns to the target.

If you do not want certain records loaded to the target IBP table, use filters.

Best regards,
Bence

[abdulmajidm]

Hi Farooq,

you can filter it out in the query
Date != '01/01/2021'

this will exclude the records with above date and extract remaining and

Date = '01/01/2021' to extract records only with this date