Linq to compare 2 excel sheets and select particular column to create 3rd sheet

[Boopathi (Boopathi Manogar)]

Hi Team,

I have a sheet1 with below values

Sheet2

I need to compare sheet1 and sheet2 and get the matched records and corresponding grade and need to generate sheet3

sheet3

Could anyone help how to complete this using linq query?

Thanks,
Ula

[bcorrea (Bruno Correa)]

you dont need linq, see this:

Story line of Join Data Table

Dear innovator’s, All we know that there is a Join Data table activity in UiPath.If we get any matching scenarios with unique value will approach join data table activity instead of filter/loop/array matching activity to find an exact match. Join Data Table: [image] Combines rows from two tables by using values common to each other, according to a Join rule, which is specified in the Join Type property. Sample Table: [image] INNER Join: The INNER JOIN keyword selects records that have m…

[ppr (Peter Preuss)]

@Boopathi
Give a try on
(From d1 In dt1.AsEnumerable
Join d2 In dt2.AsEnumerable
On d1(“Name”).toString.trim Equals d2(“Name”).toString.trim
Select d1).CopyToDatatable

d1 = sheet1
d2 = sheet2
use the statement within an assign activity and assign it to e.g dt3 (DataType: DataTable)
Kindly Note: CopyToDataTable throws an exception if returned result is empty (does mean: has no rows)

[Boopathi (Boopathi Manogar)]

Hi @ppr
I have one more query. Just consider my sheet1 and sheet2 is exists like this

Sheet1

sheet2

Want sheet 3 output like this

Could you please help me how to tweak the query. i.e i want matched column values in sheet2 also.

Thanks,
Ula

[amit_joshi]

this can be achieve with join databable also. see the attached workflow i had done it for you.
Main.xaml (9.5 KB)

[ppr (Peter Preuss)]

@Boopathi

I created a XAML showcasing this scenario with:

• LINQ
• Join Datatable Activities

It is good to know both approaches as both has cons and pros
Kindly note:

• As you will see both approaches requires some additional works / actions additional to the core Join action
• Join DataTable comes out with a column structure of all combined columns. Thats why you will get the Name_1 column (Coming from second Table Join Column).
• Join Datatable is a good alternate option as well, but the result requires some column removal. So its not doing all jobs directly without any post workings as sometimes is stated, but this fact not mentioning

Demo XAML here: Ula_TableJoin.xaml (13.0 KB)

[Boopathi (Boopathi Manogar)]

Thank you very much @ppr and @amit_joshi