topic Re: Merging 4 tables into 1 in ArcGIS Pro Questions

Merging 4 tables into 1

AndrewReynoldsDevon — Thu, 24 Aug 2023 15:02:21 GMT

Hi,

As the output of a model I have 4 tables with the same headings which I want to merge into 1 table. In Excel this is easy as you just add a new row but in Pro the merge tool only returns one value. I need a table with 4 rows in it. Each table only has 1 row of data so it needs to take each row & then add it on as a new row in the table.

Thanks

Andy

Re: Merging 4 tables into 1

DanPatterson — Thu, 24 Aug 2023 15:54:32 GMT

Append (Data Management)—ArcGIS Pro | Documentation

doesn't work?

Re: Merging 4 tables into 1

AndrewReynoldsDevon — Fri, 25 Aug 2023 08:21:17 GMT

I tried to use the Append tool however you get the same row repeated 4 times when I need unique data on each row. Each one of the 4 source tables contains a row of data that I want to combine into 1 table with 4 rows

Re: Merging 4 tables into 1

AndrewReynoldsDevon — Fri, 25 Aug 2023 13:04:34 GMT

I have a model that is run 4 times where it creates a row of data each time it's run however I need it add a new row for each time the model is run

Re: Merging 4 tables into 1

AndrewReynoldsDevon — Fri, 25 Aug 2023 13:15:01 GMT

The append tool 'Merge rules allow you to specify how values from two or more input fields will be merged or combined into a single output value. The following merge rules can be used to determine how the output field will be populated with values:'. I don't want 1 output I need 4

Re: Merging 4 tables into 1

AndrewReynoldsDevon — Fri, 25 Aug 2023 13:54:51 GMT

I need to carry out an upsert operation which you can do with the Append tool in Pro 3.1 but I have 2.8