If Excel Row matches append document number with comma

[toru]

Hello Everyone,

I’m working on Excel, so when bot posted the value in SAP there were two document number generating for same ID. Image is below

My requirement is if ID,SAP Code ,Plant Code and Header Text is same document number should be append by comma … Below Image (Expected Image)

Can anyone help on this…

Thanks

[ppr (Peter Preuss)]

@toru
welcome to the forum

it can be handled with grouping the data on SAP FP Code and processing the resulting group members.

Have a further look here:

[HowTo] Overview on different options for grouping data and processing the groups

This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items. Lets have a look on following data: [grafik] A possible scenario could be: Create a report containing following information: the region code the sum of CaseCount per RegionCode t…

refering to you screenshots also duplicated rows are to remove on advance

[Deepan_Baskaran]

Try to read the Excel file to data table, and run for each loop,
put condition for example if datatable.rows.indexof(row)+1=datatable.rows.indexof(row)
add flag for your row so that u will not process duplicate entries

[toru]

Hi @ppr,

sorry for late reply. I’m currently grouping the data on plant code and using below LINQ code. It’s not appending comma , can you help?

(From d In dt_ExtractLog.AsEnumerable
Group d By k=d(“Plant Code”).toString.Trim Into grp=Group
Let cn = String.Join(“,”, grp.Select(Function (rn) rn(“Doc Number”).toString).toArray)
Let ra = New Object(){k, cn}
Select dt_ExtractLog1.Rows.Add(ra)).CopyToDataTable

[toru]

Hi @ppr,

I’m sending the xml file which i’ve tried…
Main.xaml (8.1 KB)