Parse Date In List Mapping Step
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?
Comments
-
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
Howdy, Stranger!
Categories
- 4.4K All Categories
- 83 General
- 13 Training
- 210 Installation / Setup
- 1.2K Flows
- 110 Rules
- 271 Administration
- 213 Portal
- 498 General Q & A
- 714 Forms
- 347 Reports
- 3 Designer Extensions
- 48 Example Flows
- 58 CSS Examples
- 1 Diagram Tile
- 8 Javascript Controls
- 187 Pages
- 5 Process Mining
- New Features
- 186 Datastructures
- 70 Repository
- 230 Integrations
- 29 Multi-Tenant
- 27 SDK
- 81 Modules
- 59 Settings
- 26 Active Directory
- 12 Version 7
- 35 Version 8
- 143 Lunch And Learn Questions