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
Dedupe and sum merging values Ask a question	6	446	July 17, 2020
Trying to understand Dedupe logic Ask a question	1	339	March 20, 2020
Merge/Pivot difference Ask a question	7	420	April 27, 2020
Rejoin rows after JSON Flattener Ask a question Building-Flows	1	475	June 19, 2020
How do I encase text from a column in quotes? Ask a question	2	377	July 29, 2020

Dedupe + merge without duplicating values in cells

Related Topics