Using 'CSV to List Mapping' step

Unknown

Using 'CSV to List Mapping' step

Unknown

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

Unknown

I love this step! The Show Item Mapping Editor was a secret to find, but its super straightforward after that.