community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Compare multiple sources

jillv
7 - Meteor
‎10-28-2022 06:11 PM

Hello,

 

Hope someone can help, I'd like to compare data using multiple sources and return a result to each set of the column if there's a mismatch in any of the sources. 

 

example: 4 different sources 

SOURCE 1 SOURCE 2 SOURCE 3 SOURCE 4
IDNAMETYPECCY IDNAMETYPECCY IDNAMETYPECCY IDNAMETYPECCY
INST1HELLO1EQUSD INST1HELLO1EQUSD INST1HELLO1EQUSD INST1HELLO1CSUSD
INST2HELLO2EQJPY INST2HELLO2EQJPY INST2HELLO2aEQJPY INST2HELLO2EQJPY
INST3HELLO3EQHKD INST3HELLO3EQCNY INST3HELLO3EQHKD INST3HELLO3EQHKD
INST4HELLO4EQGBP INST4HELLO4EQGBP INST4HELLO4EQGBP INST4HELLO4_SEQGBP
INST5HELLO5FIUSD INST5HELLO5FIUSD INST5HELLO5FIUSD INST5HELLO5EQUSD
INST6HELLO6FIUSD INST6HELLO6FIUSD INST6HELLO_6FIUSD INST6HELLO_6FIMYR

 

expected result:

ID1_NAME2_NAME3_NAME4_NAMENAME_REVIEW1_TYPE2_TYPE3_TYPE4_TYPETYPE_REVIEW1_CCY2_CCY3_CCY4_CCYCCY_REVIEW
INST1HELLO1HELLO1HELLO1HELLO1MATCHEQEQEQCSMISMATCHUSDUSDUSDUSDMATCH
INST2HELLO2HELLO2HELLO2-aHELLO2MISMATCHEQEQEQEQMATCHJPYJPYJPYJPYMATCH
INST3HELLO3HELLO3HELLO3HELLO3MATCHEQEQEQEQMATCHHKDCNYHKDHKDMISMATCH
INST4HELLO4HELLO4HELLO4HELLO4_SMISMATCHEQEQEQEQMATCHGBPGBPGBPGBPMATCH
INST5HELLO5HELLO5HELLO5HELLO5MATCHFIFIEQEQMISMATCHUSDUSDUSDUSDMATCH

 

Most of the existing cases are comparing two sources only so hope to get a sample of multiple source compare.

 

Thanks in advance!

 

 

Labels:
Reply
0 Likes
1 REPLY 1
binuacs
20 - Arcturus
‎10-29-2022 12:27 AM

@jillv One ay of doing this

binuacs_0-1667028435026.png

 

Multi-Join_1029.yxmd
Reply
0 Likes
learn more about the python upgrade coming in may 2024
Labels