Articles on: Transforms

Merge duplicate rows

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

Merge duplicate rows


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.


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.

Updated on: 20/09/2022

Was this article helpful?

Share your feedback


Thank you!