Changing records in one field based on another

[kerwinhack]

I am trying to update a field based on the value in another but get this error message: Error: Formula (66): Parse Error at char(76): Parse Error (Expression #3)

This is the formula I am using:

Any suggestions?

[Emil_Kos]

Hi @kerwinhack,

you need to add space before endif and it should work.

You need it more like this:

and not like this:

[kerwinhack]

Thanks for the prompt response, I have tried that and the error is still the same: Error: Formula (66): Parse Error at char(76): Parse Error (Expression #3)

IF [Ac Record Type] = 'Person Account' THEN 'Not applicable' ELSE [Ac Industry Type] ENDIF

[Emil_Kos · Accepted solution]

Hi,

The Ac record type is in string format? 

If that is the case could you try to create a new string column with the same formula but with a different name?

[kerwinhack]

Yes, V_WString as is the AC Industry type.

[mceleavey]

@kerwinhack ,

can you post a representative sample or mock up of your data?

Thanks,

M.

[Emil_Kos]

Hi @kerwinhack,

The last thing that I would do is create a new column and check if it works. As I have created a workflow and this formula works at least in my Alteryx.

If that will not help please do as suggested by @mceleavey. Share your data with us. 

[kerwinhack]

Here is some sample data:

Ac Industry Type              Ac Record Type
Legal                                Business Account
Legal                                 Person Account

So the first record should stay as Legal and the second should change to not applicable.

[mceleavey]

Hi @kerwinhack ,

Yeah, it works perfectly:

M.

[Emil_Kos]

Hi,

Please check if this works for you: