Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
Hello!
I have one set of data and I am looking replace a row of this data if they have these specific criteria with an amount from another source.
This is an example of my data. I need to replace the value in column C with the specific criteria "605530" and "27688" with the amount in the text input. Box on the left one set of data. Image on the right is the amount that I want to replace column c with.
I attached a workflow with the data.
Thanks for your help!
hey @jessy_chow. Thanks for supplying the workflow!
What you're after here is a "join". It's effectively a "lookup" on selected columns. The columns you select effectively say "hey, if the values match in both datastreams on these selected columns, join the streams together and pop this onto the J output anchor". I'll supply a picture of before and after below & I'll attach the workflow. I've also annotated the tools to make it a little clearer for you to follow. Any questions, please let me know.
