Merge duplicate rows

The Merge duplicate rows step allows you to group rows in one or more columns and merge their values.

Input/output

The data we'll input into this step has an list of products and sizes.

After applying the process, Each group of rows has the same value in the "Size" column, will be merged in a single row separated by a delimiter.

Settings

Pick the dataset, then Type in "Merge these column(s)" the column name(s) or index(es) separated by comma,

then type in "Per unique column(s)" the column name(s) or index(es) the merge based on unique values.

Specify the "Delimiter type", also for space delimiter you can add pick it from dynamic expressions rather than typing it.