Issue Referencing A Worksheet as A Collection Field

Question

I have a collection which is gotten from a worksheet. However, when I try to reference a column name it tells me that the column doesn't exist in the collection. If I change this column name to a one worded heading such as company it works fine. Is this to do with the excel file itself or a bug in Blueprism?

Answer 1

Looks like there's some trailing spaces in your source file's column headings. When referencing the column, make sure to include these trailing spaces.

Alternatively, do some preprocessing on the source document to trim the leading and trailing spaces before importing the data to a collection.