Replacing a field from separate column

[GoldenDesign04]

I have a column that contains two locations from the extract, there is another column that indicates if they are in both locations.

I want to combine this into a single column.

I wrote a formula, also tried this in a multi-row formula with the same results, that in essence is:

IF [InBOTH] = 'Yes'
THEN [Data Source] = 'In Both'
ELSE [Data Source] 
ENDIF

Which ends up putting zeros in the Data Source column instead of the string I would like there. 

I've tried several iterations of the same logic with the same results.

????

[Jonathan-Sherman · Accepted solution]

Hi @GoldenDesign04,

Your syntax is not quite right, you were nearly there!

IF [InBOTH] = 'Yes'
THEN 'In Both'
ELSE [Data Source]
ENDIF

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[GoldenDesign04]

@Jonathan-Sherman 

This made me groan out loud. Like of course! 

I blame Oracle SQL on writing everything crazily explicit and forgetting to alter my syntax. But in reality I was just being bone headed.

Thanks for the assist!!!