Merge duplicate rows
The Merge duplicate rows step allows you to group rows in one or more columns and merge their values.
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.
Merge duplicate rows
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.
Updated on: 20/09/2022
Thank you!