V_WString Field formula returning 0 in lieu of quoted text.

[BAvitia23]

Greetings

I have a simple formula intended to correct records however the result is not what is expected I'm getting a 0 in leu of the text indicated between quotes,

Metadata

[Project] = V_WString size 4000

[uniquekey]= V_WString size 4000

The formula:

IF [uniquekey]='94669' then [Project]='TJ CUSTOMER : SKYDIO-TJ'

Not sure what needs to be changed, attached is a screenshot if it helps

[hlee36 · Accepted solution]

You are filling Project field with boolean value.

Take off "[Project] = "

So, for example, 

IF [uniquekey] = '94669' then [Project] = 'TJ CUSTOMER : SKYDIO-TJ'

-> IF [uniquekey] = '94669' then 'TJ CUSTOMER : SKYDIO-TJ'

Fix all the if and elseif statement like above.

[binuacs]

@BAvitia23 Your formula is not correct

[BAvitia23]

Thank you I think I needed an extra cup of coffee

[danilang]

Hi @BAvitia23 

Another thing you should consider is replacing this large If statement with a mapping file that you can join to the data.  That will enable you to easily change the mapping in the file as opposed to having to change the if statement in the workflow.  

Dan