Hi @AaronMark, to get your excel files into datatables simply use the excel application scope activity and insert read range activity inside “do”. The output of read range will be a datatable variable.
Then you can start using the comparison activity.
I have to do some operations on site 1,
only if the order number is present in both files.
So I thought of writing the list of common orders in a C.xlsx file.
Hi Ashish,
I don’t understand how to add the row in the posthumous table.
The script, works partially, that is,
he can find the elements in common.
ok.
Then,
I created new table to test.
When I have to set up the arrayrow, I get an error.
my string array: (row1.Item(“Purchase Order”).ToString,“Match”)
I have to look for whether the value of File 1 is present in File 2,
and if it is present, I need the relative value of Column A, of file 1. (Column Name: Service Timesheet).
To be precise:
Look for “Purchase Order” (file1) in “Approved Value PO Number” (file2)
for matches, I need to create a table that contains
the value of the “Service / Time Sheet” column, in the first column,
and the Purchase Order in the second.
Don’t concatenate… .
That data generates a list of IDs that I have to search for on a web page.