Formula based on Joined Summarize

[DC19]

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

[ChrisTX]

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

[DC19]

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

[BrianR · Accepted solution]

@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

[DC19]

That works perfectly thanks 

[BrianR]

Excellent glad it worked!

Best,

Brian