Best way to merge records with a common field into a list

bea95

• May 06, 2021 00:00

• Answered

Follow

Hi there,

I have some data that looks like this where there are duplicate values in field 1 and different values in field 2.


Field_1 Field_2
95791982 4558330929
95791982 6811305815
95791982 2077056935
75612428 7349717965
75612428 9718912488
75612428 7376005892

Would be very grateful if someone could advise on the best way to achieve something that looks like:

Field_1 Field_2
95791982 4558330929,6811305815,2077056935
75612428 7376005892,9718912488,7376005892


Thank you in advance!

• 

  Ladislav Szabo

  • May 10, 2021 10:37

  0

  Comment actions Permalink

  Hello there!
  
  There is a component in CloverDX made exactly for this called "Denormalizer".
  Denormalizer creates a single output record from one or more input records.
  
  I've attached a graph with my solution so you can have a look at it.
  (You could go with setting group size instead of key if there's fixed number of records with same key, however using key is safer.)
  Be sure to check documentation to find more about Denormalizer.
  
  Best regards,
  Ladislav.

  • Project.zip

Please sign in to leave a comment.