From input file Group rows having duplicate rows and update master according to master data

Help Activities
, ,
2

@Swara_Soni
Variables:

grafik
grafik846×190 12.3 KB

Preperations:

  • clone dtOutput from dtInput , add the result column
  • use the master data for lookups in the form of a dictionary
    grafik

LINQ, doing the job:
grafik

  • iterate over dtInput
  • group data with the help of the concat trick
  • order groups by its first member position in original datatable
  • lookup the value from master
  • use lookup or go for constructing the target itemarray
  • add the constructed rowArray to the target Datatable
  • return the count of added rows

we do return the count in order to return anything (so called silly trick). As rows.add already adds the data, we do not need selectmany, copytodatatable

The order differs from your sample sheet, but the order requirements were not derivable from it.

Find starter help here:
Swara_Soni.xaml (9.6 KB)

2 Likes