Merge similar columns and concatenate different ones

Question
1

I have a set of products with different data fields, one of which is product group. I want to create csv files for each product group, grouped by a diameter field, where similar text in merged fields are not duplicated, but where different values in fields are concatenated with a token.

For instance:

  • Name, Group, Coating, Diameter, Length
  • Product A, Rebar, None, M20, 5000
  • Product B, Rebar, PC-Coat, M20, 5000
  • Product C, Rebar, PC-Coat, M20, 6000
  • Product D, Rebar, PC-Coat, M22, 5000
  • Product E, Rebar, PC-Coat, M22, 6000
  • Product F, Rebar, PC-Coat, M22, 7000

Given a concatenate token of " / ", from this I would expect a result like:

  • Name, Coating, Diameter, Length
  • Product A / Product B / Product C, None / PC-Coat, M20, 5000 / 6000
  • Product D / Product E / Product F, PC-Coat, M22, 5000 / 6000 / 7000

How can I go about making this happen in EDT?

2

Unique will do that in 1 step.

image
image750×162 40.5 KB

image
image956×704 149 KB

unique.transform (3.0 KB)

2 Likes
3

@egilDOTnet If you don’t want to have the Group field as in your example, you need to add a remove.

image
image1325×606 97.4 KB

@Admin The power and options of unique are impressive every time.

2 Likes
4

Fantastic, this tool just keeps getting better and better! :smiley:

1 Like
5

Thanks. Please consider leaving us a review at:

https://www.capterra.com/p/198606/Easy-Data-Transform/reviews/

or