Dynamic filed name and number of fields in collection

[RashmiMalaviya]

Hi Team,

I am trying to automate manual excel work to BOT driven work. My base file is an excel sheet received every month, the column names may change every month and I need to fetch value corresponding to each column and write it in another collection and finally in another excel sheet. But I am not able to find a way to reference the dynamic column names. Please suggest

------------------------------
Rashmi Malaviya
------------------------------

[JamesMcLintock · Accepted solution]

Hi Rashmi,

Referencing dynamic variables in Blue Prism as a self-contained solution is complex to the point where leveraging human in the loop automation is more logical - depending on the scale of your automation.

There's two easy and immediate ways to do it with human in the loop:

• An environment variable in csv format that provides the mapping for the table where you a Process Controller can provide Blue Prism with the mapping to interpret.
  • Use Utility - csv to colleciton
• A mapping file owned by the business which the robot can interpret, Excel based file saved as .csv
  • Use Utility - csv to collection

Where column references are being used, I would usually refer to an environment variable, map the variables and them the process agnostic of the names after that: in our own CoE we have a dynamic directory tied to a .csv which translate what the robot wants into terms it understands.

Hope this helps, 

James

------------------------------
James McLintock
Process Analyst and Developer
Blue Prism
Europe/London
------------------------------