topic RE: Foundation training - consolidation exercise, linking file to data item. in University Forum

Foundation training - consolidation exercise, linking file to data item.

FedericoMauri — Thu, 26 Nov 2020 11:56:00 GMT

Good afternoon, everyone!
I am doing consolidation exercises of foundation training and am trying to create process as described in the slides.

File excel (Orders.csv) will be the input of this process. But how can I insert the file path inside data item?

------------------------------
Federico Mauri
------------------------------

RE: Foundation training - consolidation exercise, linking file to data item.

jhogelp — Thu, 26 Nov 2020 14:24:00 GMT

Hi! Federico M.

In the Action Open Worbook in the input parameters:

handle: Data Item [Handle] (This value is obtained from the Action Create Instance Parameters output)
File name: Data Item [File Path] (The value is file path example: C:\Orders.csv)

If you want to change the path of the Data Item File Path, you can open it and change the Initial Value (Data Properties) with the new path and click the Ok button to save the changes

I hope this help!!

Cheers

------------------------------
Jhogel Ponne
Senior RPA
Ernst & Young
America/Panama
------------------------------

RE: Foundation training - consolidation exercise, linking file to data item.

NrupalJoshi — Thu, 26 Nov 2020 14:24:00 GMT

Hi Federico

Not sure I truly understand your question, but if your excel file is residing on a different path on your computer, just shift right click on your folder and copy as path. You can then open the data item and change the path in the "current value" field.

Hope this helps

------------------------------
Rup Joshi
------------------------------