Hi,
I have 4 fields of product codes that I want to merge them into a single field (WITH A FORMULA TOOL) based on:
Please see table below
1st row: if they all contain "same" field names, only display one outcome
2nd row: if only some fields are the same, seperate them with a dash (-)
3rd row: if there is only one entry in any of field 1, 2,3,4 display it on the newfield (or if there are two entries, display all etc)
4th row: if field 1,2,3,4 are all empty, display nothing " "
5th row: If they are all different, display all in "newfield" and seperate them with a dash
Field1 | Field2 | Field3 | Field4 | NEWFIELD |
AB | AB | AB | AB | AB |
AB | CD | AB | SD | AB-CD-SD |
AB | AB | |||
AB | BC | DC | FD | AB-BC-DC-FD |
Solved! Go to Solution.
Thanks for the attachment...I actually have a similar workflow that works for my case but I'm particularly looking for a single formula function
Like if field1=field2 then...etc
Again thanks for the workflow though
Thank you, @acerdell, for accepting my answer. In terms of a single formula to produce the same output, I don't think there is one without a really complex conditional expression. This approach though would be dynamic in the fact that if there's more fields added, this would still solve for that without modification, as opposed to a formula, it would require you to make some modifications to the expression on those instances.
Best,
Jimmy
That is what I realized too. I had a similar worflow but it looks like that it has some issues, but yours is well built. Thanks again