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
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
you dont need linq, see this:
@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)
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
this can be achieve with join databable also. see the attached workflow i had done it for you.
Main.xaml (9.5 KB)
I created a XAML showcasing this scenario with:
It is good to know both approaches as both has cons and pros
Kindly note:
Demo XAML here: Ula_TableJoin.xaml (13.0 KB)
Thank you very much @ppr and @amit_joshi
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.