load csv data into a running workflow to a variable

​@mshealy 

That could be failing for many different reasons.  Do you have any more information on what the error is or what is not doing? 

The most common reason is a mismatch between CSV column headers and Variable property names.  CLM is case-sensitive and spacing-sensitive too.

This is the variable and csv file. 

​@JohnSantos any ideas?

​@mshealy 

1. You have two columns on the CSV file without a name.  Removed them if you don’t need them.
2. Remove blank rows at the bottom of the CSV.
3. Check for trailing spaces or hidden characters from headers in the CSV.
4. Delete invisible BOM characters by saving the CSV as UTF-8 without BOM.
5. Confirm that you’re targeting the correct variable in the workflow: use PartyListCSV.party, not PartyListCSV.
6. Confirm your workflow step is “Set Variable from CSV” and not “Set Variable from Data”.

I only have these two steps to choose from

Create variable from csv

Update variable from csv

I don’t have a set variable from csv step option.

​@mshealy 

Show me a screenshot of your “Create Variable from CSV” configuration.

​@JohnSantos 

​@mshealy 

I think you are pointing the output to the wrong variable level. In your Output, choose PartyListCSV.party.  And run it again.

I have it running but it is only return one row. ​@JohnSantos 

​@mshealy 

It looks like your CSV has some hidden characters after the first row.  That’s why CLM will import only one row.  You need to normalize the file by removing any hidden tabs and unused columns.  Did you remove columns O and P?