I'm searching for a solution for this: I have an excel file with headers that contain "." this is a problem for Blue Prism because it can't work with it to set a value.
For example I have ExportCollection with column A, B. and C
if I use the calculation for this collection to parse it to another collection with column A and B, I would do this:
[ExportCollection.A] store in [NewCollection.A] [ExportCollection.B.] store in [NewCollection.B]
now the last one will give me an error.
My solution was, maybe I can extract the data into my ExportCollection without headers but I don't know how to do this.
Can someone help me with this?