Hi all,
I am looking to use a Join tool to combine two sets of data. The first (select) has one row of data and the select has only selected 5 columns .
The second (summarize) has one line of summarized data with 5 different individual fields and values.
How do i Join these two together in one item so i can then use the formula tool to create a formula based off the numbers from both sets of data. Preferably the join output would be in one line of values with the column name
Appreciate any help.
Many thanks
Solved! Go to Solution.
Can you share sample input data?
Can you use the Join tool with the option Join by Record Position? If not, how are the records from the Select related to the records from the Summarize?
Chris
Hi Chris,
Thanks for your response, these fields are not related that is the problem but i need them in the same row in order to use the formula function effectively.
This is the output from select
While this is the outcome from summarize
Many thanks for your help
@Hi @DC19, ideally you would have some key field to join on, but as you mentioned, you don't have that. Take a look at the Append tool:
That should allow you to get your values on the same row for your calc - in my sample, I mocked up your displayed data, and this is the output of the Append tool:
Let me know if this would work for your data.
Brian
That works perfectly thanks
Excellent glad it worked!
Best,
Brian