Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

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

4 way reconciliation

jillv
6 - Meteoroid

Hi,

 

Would like to get some help on creating a 4-way reconciliation that will only spit out the "differences". 

 

Source1:

IDcountrycurrencytype
sec1USUSDeq
sec2USUSDeq
sec3CACADeq
sec4SGSGDeq
sec5HKHKDeq

 

 

Source2:

IDcountrycurrencytype
sec1USCADeq
sec2USUSDfi
sec3CACADeq
sec4SGSGDeq
sec5HKHKDeq

 

 

Source3:

IDcountrycurrencytype
sec1USUSDeq
sec2USUSDfi
sec3CACADeq
sec4SGSGDeq
sec5JPJPYeq

 

Source4:

IDcountrycurrencytype
sec1USUSDeq
sec2USUSDeq
sec3CACADeq
sec4SGSGDeq
sec5HKHKDcsh

 

 

Result:  should show the values of the specific fields of all sources when there is a break/breaks. If all of the values matched or when there is no break, then they don't have to be in the results. 

IDFieldSource1Source2Source 3Source 4
sec1currencyUSDCADUSDUSD
sec2typeeqfifieq
sec5countryHKHKJPHK
sec5currencyHKDHKDJPYHKD
sec5typeeqeqeqcsh

 

It is easy to do this for 2 way rec, but I couldn't figure out once I added more sources in the mix. Appreciate any assistance on this. Thank you.

 

 

4 REPLIES 4
gautiergodard
12 - Quasar

Hey @jillv 

Here is one way to do it which got me to your desired result.

gautiergodard_0-1672875461398.png

 

Please accept as solution if this solved your issue.

 

Hope this helps!

Qiu
19 - Altair
19 - Altair

@jillv 

This is a quite static one but should give some idea.

0105-jillv.PNG

ArtApa
Alteryx
Alteryx

 Hi @jillv - One more way to achieve the same:

 

ArtApa_0-1672887255687.png

 

jillv
6 - Meteoroid

thank you everyone for those who answered, I really appreciate it!

Labels