Variable with RPA(UIPath)

1. RPA,  How to use a variable with assign activity

1) string

Making the File Path with string variable and assign activity

UIPath_Variable_string
UIPath_Variable_string

Value to Save :
“folder_email\price_temp.xlsx”
“folder_email\price_result.xlsx”

2) array

UIPath_Variable_array
UIPath_Variable_array

3) List

Initialize a list variable

UIPath_Variable_list
UIPath_Variable_list

4) Datatable

Initialize a datatable variable

UIPath_Variable_datatable
UIPath_Variable_datatable

2. How to use two more variables with FOR activity

1) String and List

Make a list from a string by using Split(“,”c).ToList  

splits it at every comma, producing an array of substrings(List)

UIPath_Variable_list_string
UIPath_Variable_list_string

The bottom one,

When you use the list with For Each to do something. In this case, it used for “Append item to List”

2) Dictionary and Datatable

Initialize a dictionary variable and DT(“passscore”) into DIC(key,value) with For Each Row in Data Table

UIPath_Variable_dictionary_datatable
UIPath_Variable_dictionary_datatable

 

In this case, needed to convert objects in the Datatable into int32 in the Dictionary 

3) Array and Datatable (Excel)

Making multiple Datatable into Excel  with sheet names

UIPath_Variable_array_datatable
UIPath_Variable_array_datatable

 

UIPath_Variable_array_datatable
UIPath_Variable_array_datatable

Official RPA, UIPATH site : https://www.uipath.com/
All of UIpath Information : https://eunice0121.com/category/uipath/