Dynamic filed name and number of fields in collection

RashmiMalaviya — Sun, 02 Aug 2020 09:23:00 GMT

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
------------------------------

RE: Dynamic filed name and number of fields in collection

JamesMcLintock — Mon, 03 Aug 2020 14:23:00 GMT

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
------------------------------

topic Dynamic filed name and number of fields in collection in Product Forum

Dynamic filed name and number of fields in collection

RE: Dynamic filed name and number of fields in collection