Using 'CSV to List Mapping' step
Comments
-
Hello! Im Ross with Decisions, and this is a quick example post of how to use the [i]CSV to List Mapping[/i] step.
I recently received a question about grabbing a single column from an Excel spreadsheet and incorporating that data in a flow. The person asking the question had been using a truth table or creating a data structure to load the spreadsheet into, which was how they used the data. They wanted a more efficient way of doing that. So here it is! (This example was made in Decisions 4.0)
Under [b]Integration > Excel and CSV[/b] there is the [i]CSV to List Mapping [/i]step. This step allows you to read a spreadsheet file and then assign each column to data member. This includes complex and user-defined data types. In this example, well just be reading a column of a spreadsheet into a list of Strings.
You may need to refer to the attached images.
In the image Employee Spreadsheet
-
I love this step! The Show Item Mapping Editor was a secret to find, but its super straightforward after that.
Howdy, Stranger!
Categories
- 4.4K All Categories
- 81 General
- 13 Training
- 209 Installation / Setup
- 1.2K Flows
- 110 Rules
- 270 Administration
- 213 Portal
- 497 General Q & A
- 711 Forms
- 346 Reports
- 3 Designer Extensions
- 48 Example Flows
- 58 CSS Examples
- 1 Diagram Tile
- 7 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