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.
I have 2 tables that I need to join together, but the join criteria changes based on a parameter from one of the tables. I wanted to see if there was a way for modifying the join parameters dynamically instead of creating 20 different join workflows and then merging the results back together. Please see below:
I don't quite understand the data well enough to answer completely. I would expect the join information to look like: LeftInput Field = RightInput Field (possibly repeating if multiple fields are used in the join). Then for bonds it is Field 1 = Field X and for cash it is Field 1 = Field Y.
Using a CReW macro (Dynamic Formula) I would construct a JOIN FIELD for each input where the JOIN FIELD is calculated from the incoming data stream and the JOIN is simply setup to JOIN on Left JOIN FIELD = Right JOIN FIELD.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.