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
Solved! Go to Solution.
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.
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
thanks mate, I think this is the formula I'm looking for but I'm facing this issue.
ahh yes! I got it...but it doesn't seem to be auto populating the word ASC in the new field.
Regards,
Lance
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
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).