CSV Datamapper - Workflow Condition

OL Connect Professional Workflow
1

Hello All.

I have a datamapper, well structured based on CSV files, there over 600 fields per record and maybe 500-1000 records per file. I need to validate each record based on comparisons between fields. For example, and to keep things simple, I want check the value of field 1 with several other fields

Basic logic is as below.

If field1 =“2026” and field6 and field7 and field8 and field9 are empty set true
else
set false.
(I may need to extend this to compare field 2 with fields 10,11,12,13) etc)
If true I want to divert the record to an exception path.
If false I want to keep the record and append to each false record for processing in bulk.

I think I need to split the file into individual records and run a workflow script but not sure how or indeed if there is a better way maybe using the datamapper.

Any help would be appreciated.

Thanks

2

You could run a Datamapper with your rules set as fields for each records and the use the Retrieve Items in Workflow to only get the records that match your rules.

See attached Data, Datamapper and Workflow config. No worry for the data, it is generated randomly by an internal app.

example.OL-workflow (49.3 KB)
Rules.OL-datamapper (115.5 KB)
SampleData.zip (114.8 KB)

1 Like