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.
Do you use Alteryx in a language other than English? If so, we want to hear from you! Please help us improve the international experience of our products by participating in this 5 minute survey.
We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.
All - As my question will show, I'm quite new to Alteryx. I"m trying to update a field in one data source 'PatientInfo' based on whether or not the information appears in another data source 'PatientInfoUpdates'. Sample data follows:
What I'm trying to do is change ID in PatientInfo to reflect the new values in PatientInfoUpdate (assume the Name matches are unique). I can see the differences by using the join tool on name and seeing the results, but can't figure out how to write the new values back to ID in PatientInfo. I'm working with the results of the join tool, which returned 2 rows, one for Adam and one for Carol as expected. I've tried a formula like this:
which errors out. I'd appreciate any ideas you all might have.
Hey @JoeDen! As you stated, since you are joining on the name field, you are under the assumption that they will be the same in order to come out the J.
To fix your error, if you want to update the ID field, do not put a new field name in the Formula configuration for Output Column. Instead, select your ID field. Then, in the expression, you will want to take out the "[ID]=" portion. The way the if statement works in Alteryx, after the 'then' and before the 'else' you just have to put the value you want the output column you chose to be equal to. See the example below for a better visual. Hope this helps!