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.
Hello, I am new in Alteryx World buy right now I am struggling to find a way to change 2 fields values with the same condition, I would say at the same time, I have seen some instruction like this to happen, only one sentence and changes 2 fields at same time, this is a SQL Type sentence:
UPDATE [TABLE] SET [FIELD1]='VALUE1 , [FIELD2]='VALUE2' WHERE SBG=[COND1] AND SBU=[COND2];
Hopefully someone with SQL knowledge could check the result of sentence above and find a similar tool in Alteryx to replicate the same. Thanks in advance.