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	691	July 10, 2020
Rejoin rows after JSON Flattener Ask a question Building-Flows	1	531	June 19, 2020
More updated steps this week! Announcements	0	500	October 27, 2020
Trying to understand Dedupe logic Ask a question	1	398	March 20, 2020
Create new column removing duplicate text Ask a question Building-Flows	4	517	August 31, 2021

Dedupe + merge without duplicating values in cells

Related topics