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.
The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs.
If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.
i'm new to Alteryx and trying to solve for an issue where i have 3 columns of names - first, middle and last. The middle name/initial is only populated in a few rows which pushes the last name to the third column in some cases. In most cases, the last name is in Column 2 so Column 3 is [NULL]. I changed [NULL] to 0 and now i want to replace the 0s in Column 3 with the value in Column 2. If there's an actual last name in Column 3 then i would like to keep that value. This would leave me with the few last names that were already populated in Column 3 and then essentially move the last names from Column 2 over to Cso that i'm capturing all last names in one column.
i am trying an IF statement with Replace but it's not working. i think there's a way to also use ISNULL but i couldn't figure that out so i changed NULL to 0. i know this is not right but i'm showing what i was trying just in case it helps.
IF [Receiver Name3]="0" THEN Replace("0", [Receiver Name3], [Receiver Name2]) ELSE "" ENDIF