Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Join Tool

ayadav8
8 - Asteroid

Hello,

 

Is there a way I can join two sets of data together in the attached table format?

 

Thanks

5 REPLIES 5
JacobMoncla
8 - Asteroid

 I think this can be done by using "Join by Record Position" option in the Join tool, and then unioning the remaining data so that it's below the first two joined records.

 

joinbyposition.PNGoverallworkflow.PNGresults.PNG

 

ayadav8
8 - Asteroid

@JacobMoncla Sorry I forgot to mention, I have multiple Titles in both the tables which need to be joined together. So I guess we need a better logic to work for all titles

JacobMoncla
8 - Asteroid

No worries, could you provide an example of the titles that you would like to join together?

fharper
12 - Quasar

At first this looks simple but on inspection it is an interesting problem.  I feel there is not enough info yet. 

To clarify you have two files, each with a title and data column

  • There may be one or more title values and each may be duplicated one or more times in both files
  • The data values...will they be unique across a title value or could they be duplicated within a given Title value?

CaptureX.PNG

 

  • And if I understand correctly from the first solution offered you only want the first occurrence of a title in file 1 matched to the first title of same value in file 2 and then they are not to be matched to any other.

If I am correct in the latter then a Sort followed by a Multi-Row tool can be used to create a record ID within the scope of a title value and then used in the Join in addition to the Title value to insure you only use a record once from each file in the matching.

 

I have provided an expanded sample data file plus workflow.

 

 

ayadav8
8 - Asteroid

@fharper This is great. Your assumptions were right. Works fine. Thanks a bunch!

Labels