How to combine multiple files into one?

[gc-804]

Hello,

I have four sets of data files in Excel (see attached for simplified version) and want to combine them into one file. I used Union to bring them together and then used the common field - Description to Summarize the data in order to get the following output. However, some data dropped from Union. What should be done differently to include all data in the below expected format and results? Thanks!

Description	T - Box 1	T - Box 2	R - Box 1	R - Box 2	TA - Box	RA - Box
AAA	11	22	D
BBB	13		N
CCC		23		M
DDD			S	S-1
EEE						B
FFF						C

[fmvizcaino]

Hi @gc-804 ,

I'm sharing two examples of workflows to accomplish what you need. 

Best,

Fernando Vizcaino

[gc-804]

Hi @fmvizcaino,

Thank you for the prompt help! The method 1 is close the results I am looking for, but R - Box 1 and R - Box 2 were not brought in (I wonder if they were dropped from Union and that was what happened to me) and the value in RA - Box has displayed twice for EEE and FFF. Because R - Box 1 and R - Box 2 were not brought in, it caused error to Summarize tool in method 2. Any way to resolve this?

Thanks!

[fmvizcaino · Accepted solution]

Hi @gc-804 ,

I'm attaching the result table from my example.

If you are not getting the same with your workflow, maybe the union tool configuration are concatenating based on position or manually. The configuration needs to be as below:

Best,

Fernando Vizcaino

[gc-804 · Accepted solution]

Hi @fmvizcaino,

I do have the same setting in Union. When I applied your approach to my workflow, it does work. Thanks!

[Dfreemont]

It does not work