Parse Date In List Mapping Step

NonPlayerCharacter

My process takes in a CSV file and creates a simple database data structure using the CSV To List Mapping step as a mediator. I have a date field with a value passed in as DDMMYYYY, but the database data structure requires it to be DD/MM/YYYY. How can I convert this value?

Nathan_Decisions

This can be done by using the Default Converter flow Convert String to Date within the Mapping Editor of the CSV To List Mapping step.

Choose Show Item Mapping Editor and a pop-up window will open. Here you will map the Field from your CSV file to the appropriate database data structure field on the right-hand side. In my case, it would be HireDate. You will change the Action to Run Converter and choose Convert String to Date.

Building and Using Converter Flows: https://documentation.decisions.com/docs/using-converter-flows