community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Matching Criteria applied on Join block

Hi,

 

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:

 

DEAL TYPECOMPARE COLUMNSINDEX COLUMNS
BondsDealsint_NetAmountSecurityId,CashAccount,Currency,Quantity,TradeDate,SettlementDate
Cashint_NetAmountSecurityId,CashAccount,Currency,TradeDate,SettlementDate

 

Capture.PNG

How would I be able to do just one Join with a dynamic input from the table above? 

 

Thanks!

 

Edgar

 

Alteryx Certified Partner
Alteryx Certified Partner

@edasilva80,

 

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.

 

My thoughts.

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Labels