Multi Row Formula

Austin_Riggs

Hello All,

I am trying to rename duplicate customer names with  (Customer Name + Customer ID), however when i union them back after the Unique i receive the data below. Is there a way to rename the Customer Name with the one below based on Customer ID  (If they are equal)? Let me know if i need to present a better example, i am using client data and cannot post it on here. Please let me know if you have any questions, thanks.

ACCU001B Accu Surg <-- Want to rename this one to the ones below
ACCU001B Accu SurgACCU001B
ACCU001B Accu SurgACCU001B
ACCU001B Accu SurgACCU001B
ACCU001B Accu SurgACCU001B
ACCU001B Accu SurgACCU001B
ACCU001B Accu SurgACCU001B

DanielMS

Hey @Austin_Riggs 

Try using this :

If !Contains([Customer (After Unique/added ID to duplicates], [ID]) AND !IsEmpty([Row+1:Customer (After Unique/added ID to duplicates])

THEN [Row+1:Customer (After Unique/added ID to duplicates]

ELSEIF !Contains([Customer (After Unique/added ID to duplicates], [ID])

THEN [Row-1:New Field]

ElSE [Customer (After Unique/added ID to duplicates]

ENDIF

Those 0/-1 s maybe popping up if the data type you've set for the new field isn't a V_WString, also make sure to group by ID in the configuration window of the multi-row formula tool.