Wild card lookup to update another field.

[jdelaguila]

Good Afternoon,

Hope everyone is doing well. I have an update statement that i believe to be very simple, but i just can't figure it out.

I have two fields [COMPANY], [DROPREASON].  See attached workflow.

Everytime the word "Fund" or "Trust" appears in the [COMPANY] field - i need to update the [DROPREASON] field with "08"

Its basically a wild card. I tried building the formula out using the CONTAIN tool but had no luck, then i tried the Find and Replace tool, but that updates the same field. Any thoughts?

[AbhilashR · Accepted solution]

Hi @jdelaguila, you could use the following formula to populate the DROPREASON field.

IF Contains([ICOMPANY],'Fund')
OR Contains([ICOMPANY],'Trust')
	THEN '08'
ELSE Null()
ENDIF

[RobertOdera · Accepted solution]

Hi, @jdelaguila 

Try this.

Please mark as solution + like, if it works for you.

Gave you both options.

The workflow is attached.

Cheers!

[jdelaguila]

Thank you both so much! This is exactly what i was looking for.

Javier Delaguila

[RobertOdera]

You're most welcome @jdelaguila !

Cheers.