How to merge rows from one datatable

[testbb (ttbt)]

hello. I have a question while using datatable.
As in the first image, we try to find a row with the same size and product no (the number of rows is unknown) and put a value in the blank space based on the first row.
Empty columns can change every time and are not fixed.

How can I combine them like the second image?
(One data table.)

Thank you!

[keerthi3595 (Keerthana M)]

Read Range to data table Dt1 and copy data table to Dt2.
Remove qty, AA, BB, CC column from DT1
Remove CC, DD, EE, FF column from DT2
Join Datatable with common column Product no

[testbb (ttbt)]

Thank you for answer. But I don’t know which column might be empty.
So it’s not easy to remove fields that are empty

[ppr (Peter)]

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 …

[ppr (Peter)]

Cross Reference:

How to merge rows from one datatable

hello. I have a question while using datatable. As in the first image, we try to find a row with the same size and product no (the number of rows is unknown) and put a value in the blank space based on the first row. Empty columns can change every time and are not fixed. How can I combine them like the second image? (One data table.) Thank you! [image] [image]

[Emre_Ayyildiz]

You can check the workflow I made. I tried to explain the steps in workflow.

I used for each loop(column) in for each datarow loop to reach all the cell. I filtered the table by size and product no. Then select the row that is not empty and set it to the current cell. After loops over, remove the duplicate lines.

MergeRows.7z (108.2 KB)

[testbb (ttbt)]

Thank you !!!