Hello, I am at the last step of my flow where I merge rows with the same ID. The problem is for lines like this: [Capture] The phone number is the same, the e-mail is the same, the type of partner is different. Thus, I would like one row with the e-mail, the phone, and “typeA,typeB”. But I ge…

SOLUTION (might be some simpler ones): Unpivot the table to create rows which are ID | TYPEOFDATA | VALUE. Merge the three columns to create unique values in a NEWCOLUMN Dedupe NEWCOLUMN, no merging Filter rows with blank values in VALUE Pivot Merge rows according to ID Find double commas and repl…

Dedupe + merge without duplicating values in cells

Ask a question

Joachim_Brindeau July 10, 2020, 7:40am 5

I just added the feature request here.
Please vote !

2 Likes

Topic		Replies	Views
Improve merging in dedupe step Feature Requests Building-Flows , Transform , Other-Request	0	697	July 10, 2020
Merge text based in another column value Ask a question	3	479	March 8, 2024
Rejoin rows after JSON Flattener Ask a question Building-Flows	1	540	June 19, 2020
More updated steps this week! Announcements	0	517	October 27, 2020
Create new column removing duplicate text Ask a question Building-Flows	4	555	August 31, 2021

Dedupe + merge without duplicating values in cells

Related topics