Just learning UIPath and trying to set a variable based off a data set from a query. Currently set up as:
Execute Query: “SELECT * FROM tblSKUListingFiles WHERE LastUpdate <> date()”
VendorList is a variable set as Datatable to Main Scope
Foreach item in “VendorList”
A-B Assign VNbr = VendorList.Select(“VNbr”)
Vnbr is a variable set to Int32 Scope Main.
This is where I get my compile error. It says it cannot assign from type 'System.Data.Datarow to type System.Int32 in Assign Activity ‘Assign’.
This is where I’m trying to set the variable VNbr to be whatever the item is in the query for that row. The ForEach will loop through so I need to change that variable each time.
Thanks for any and all help.