This worked for me too:
out1.id = fields.id
out1.Color = group.joinStrings(fields.Color, False, ', ')
------------------------------
Sam Darmo
Precisely Software Inc.
PEARL RIVER NY
------------------------------
Original Message:
Sent: 05-23-2023 02:42
From: Dhinmar James Cayog
Subject: Data Transformation
This worked! Thanks a lot!
------------------------------
Dhinmar James Cayog
Knowledge Community Shared Account
Original Message:
Sent: 05-22-2023 06:02
From: Eugenio Borrelli
Subject: Data Transformation
Hello,
The solution I found is to use an aggregate node as follows:
Grouping by 'id' field and using the "group.joinString" method on the "Color" field
Kind regards
Eugenio
------------------------------
Eugenio Borrelli
Assistant Data Analyst
Linklaters
London, UK
Original Message:
Sent: 05-19-2023 06:41
From: Dhinmar James Cayog
Subject: Data Transformation
Hi,
I'm looking for a way to do the following data transformation within data360.
I have an input data and I want to process it to have the following output:
Input:
Output:
Appreciate any suggestions. Thank you!
------------------------------
Dhinmar James Cayog
Knowledge Community Shared Account
------------------------------