autofill field

[lancegoh1]

hi can someone guide me as how do I filter out cells that contains text ([Name of Reviewer]) and do a autofill in a new field ([team]) if the previous field ([Name of Reviewer]) contains text.

Original input:

Name of Reviewer	Team
John
#N/A
Mary
James
#N/A

Desired Output:

Name Of Reviewer	Team
John	ASC
#N/A
Mary	ASC
James	ASC
#N/A

Cheers,

Lance

[mceleavey]

Hi @lancegoh1,

I've attached the workflow with the formula. You can change the value, such if isnull, or isempty, or whatever it happens to be. In this example I've simply used if contains on the # symbol.

Let me know if this is what you're after.

M.

[lancegoh1]

aww mate I'm using an older version of alteryx (work PC, updating would require going through IT which is almost impossible). is it possible to show me in picture form?

Cheers!!

Lance

[mceleavey]

Ha, no problem.

This shows you the formula applied to the Team column.

The select tool simply ensures the Team column has enough characters.

EDIT: For clarity, here's the formula:

if !contains([Name of Reviewer],"#") then 'ASC' else '' endif

[lancegoh1]

thanks mate, I think this is the formula I'm looking for but I'm facing this issue.

[mceleavey]

Remove the [Team2]= from the beginning.

[lancegoh1]

ahh yes! I got it...but it doesn't seem to be auto populating the word ASC in the new field.

Regards,

Lance

[mceleavey]

You're assigning a '' to a null field. use if isnull(field) or !isnull()

EDIT: if isnull([Right name of reviwer]) then 'ASC' else '' endif

[lancegoh1]

hi mceleavey,

thanks for your patience,

the expression makes sense, however my last field [Team2] is still filling '0' for all the rows.

Regards,

Lance

[mceleavey · Accepted solution]

Hi @lancegoh1,

no problem. I can see you still have the [Team2]= part at the beginning, you need to remove that.

Other than that it's simply a question of ensuring you're using the correct values (ensure the field is null and not empty).