because of empty columns inbetween we arent able to processit
the actuall process will be like this
–use excel application scope and pass the file path asinput
–inside the scope use read range activity and get the output with a variable of type datatable named dt1
–now use another excel application scope and repeat the same for the second excel file
and get the output datatable as dt2
–now use a FOR EACH ROW activity and pass dt1 as input and inside the loop use LOOKUP DATATABLE ACTIVITY where mention these in property panel
input = row(“yourcolumnname”).ToString
datatable = dt2
lookup column name = "your columnname in dt2 taken as lookup"
out result = str_output //a string variable
target column name = "your columnname in the dt2 whose value will be taken as output"
then followed by this lookup datatable activity next use WRITE CELL activity within the for each row loop with input value as str_output and range as
in sheet mention the sheetname
hope this would help you