This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Thanks @Thableaus for your reply, Your solution will change the all value in all rows in case of the value NO, Sorry let me clarify more, I want only the value against PO in case of NO to be changed to NA not for all.
As per the example below to change NO value against PO field only.
I mean that there is a value in another column beside PO either Yes or No and I want to replace this value with NA in case of No, You helped me indeed however I have noticed that all fields changed as well such as the value beside Invoice it was No and changed with NA so Is there a formula to change the value beside Po only in case of No, Also PO value might be in a column A and in another row will be in column B so how to solve this, Thanks in advance!
Many thanks Thableaus, This is absolutely what i look for...........
Just last question if you don't mind, How do i add multiple condition in the same provided workflow Example: In case of Type MKT and the field beside "Actual attendee" equal NO and field beside "Invoice" equal NO to be replaced with NA also in case of Type HR and the field beside PO equal NO to be replaced with NA
Many thanks Thableaus for your support, This is helped me a lot and apologize for my late in respond as this workflow takes a while to apply on my dataset, Also i am a new user using Alteryx.
I have another question, Attached is my dataset, I want to use use formula stating that in case of the cell beside PO = NO and Cell beside Invoice = Yes OR the cell beside PO = Yes and Cell beside Invoice = No then replace NO with Yes, Else [Value] ENDIF.