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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

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