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
Solved! Go to Solution.
Hey @Austin_Riggs
it will be something like:
If [Row+1:Customer] = [Customer] Then [Row+1:Customer]+[Row+1:CustomerID]
Else [Customer]
ENDIF
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 |
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.