Hello,
Is there a way I can join two sets of data together in the attached table format?
Thanks
Solved! Go to Solution.
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.
@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
No worries, could you provide an example of the titles that you would like to join together?
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
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.
@fharper This is great. Your assumptions were right. Works fine. Thanks a bunch!