Creating conditional new field via formula tool IF statament

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

Transformation

Accepted answers

jgo

Hi @acerdell,

See if this workflow contains the solution you're looking for...

Best,

Jimmy

New Workflow1.yxmd

All comments

jgo

Hi @acerdell,

See if this workflow contains the solution you're looking for...

Best,

Jimmy

New Workflow1.yxmd

acerdell

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

jgo

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

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335