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

[LordNeilLord]

Hey @Austin_Riggs 

it will be something like:

If [Row+1:Customer]  = [Customer] Then [Row+1:Customer]+[Row+1:CustomerID]

Else [Customer]

ENDIF

[Austin_Riggs]

Hey @LordNeilLord

I am getting 0,-1's do you know why? Also below is a better data set, thanks for the help

ID	Customer (After Unique/added ID to duplicates
ASCE001B	Ascension
ASCE001B	AscensionASCE001B
ASCE001B	Ascension ASCE001B
ASCE001B	Ascension ASCE001B
ASCE001B	Ascension ASCE001B
ASCE001B	Ascension ASCE001B
BARN001B	American
BARN001B	American BARN001B
BARN001B	American ARN001B
KAIS001B	Kais
KAIS001B	KaisKAIS001B
KAIS001B	KaisKAIS001B
KAIS001B	KaisKAIS001B

[DanielMS · Accepted solution]

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.