Use linq to join rows

[Angel_Llull_Rivero1 (Angel Llull Rivero)]

Hello, I would like to know how can I do it with linq to pass from:

to:

Thanks

[ppr (Peter Preuss)]

have a look here:

Can you join datatable without duplication?

@sidb With one of my work fellows @kumar.varun2 we developed an approach we merged all dt into one grouped on the ID created from each column from the groupmembers a helper tuple filtered out the empty value ones driven by the data column schema we build the itemarray where missing ones were creared with empty vlaues added the merged row to an result datatable Varun will continue on this approach with details and samples we were also able to extend this approach to merge multiple datatable …