How to read and write cells based on look up

[sathish_Kumar6 (sathish Kumar)]

In first excel sheet1 i have Acolumn and in sheet2 i have Acolumn if both matches then I have to get the sheet2 value of bcolumn in sheet2 and check the bcolumn in sheet3 and if sheet2 b column matches with sheet3 b column then it has to take the value of currentrow of b column in sheet 3 and the current row has 2-12 string cells values and 2-12 integers cells so if b column matches then take current value for example if matches currentrow has two strings and two integers means it has to take that two strings and transpose beside to A column in sheet 1 as bcolumn as two strings transpose and c columns two integers transpose like wise if 2-12 are there if matches has 12 means it has take transpose beside to Acolumn and append it

I have done the automation
But i would like to know how to do this in linq query or any other method so I can reduce the time it takes to complete the automation

Excel_sheets.xlsx (11.7 KB)

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @sathish_Kumar6 ,

LINQ query to find data present in another excel if data matches with corresponding value

@sandyk the join type is currently not derivable from the description as it is not specifying on how to handle non matching city codes from dt1 in dt2. The join datatable would help to do it with an out of the box uipath activity. Doing it with LINQ could look like this: (From d1 In dt1.AsEnumerable Join d2 In dt2.AsEnumerable On d1("City_Code").toString.Trim Equals d2("City_Code").toString.Trim Select d2).CopyToDataTable Find starter help here: Match_1Col_ResultKeyColMatchVal.xaml (8.6 K…

hope it help you!
regards,

[sathish_Kumar6 (sathish Kumar)]

Actually i think it doesnt meet my requirement… i need to get the matched requirement and put it output sheet and transpose the strings and numbers beside to A column as B column and c column