https://community.esri.com/t5/modelbuilder-questions/modelbuilder-output-is-empty/m-p/1096376#M3944 <P>I built a model builder to automate a process I run weekly. It's a few tools running after each other and then two sources are merged in a spatial join and then table to table is run to get a csv output. When I run the model, the text columns in the output return no value, they are empty. These columns are not calculated in the process, they're included with the input. But the column I'm calculating in the process is coming out with correct values. however, all other text data that is an input for the model is not coming out in the output, but I need it. I'm not sure what the issue here with the model. Any tips or advice would be highly appreciated.</P> Wed, 08 Sep 2021 14:17:02 GMT GISLearner 2021-09-08T14:17:02Z https://community.esri.com/t5/modelbuilder-questions/modelbuilder-output-is-empty/m-p/1096376#M3944 <P>I built a model builder to automate a process I run weekly. It's a few tools running after each other and then two sources are merged in a spatial join and then table to table is run to get a csv output. When I run the model, the text columns in the output return no value, they are empty. These columns are not calculated in the process, they're included with the input. But the column I'm calculating in the process is coming out with correct values. however, all other text data that is an input for the model is not coming out in the output, but I need it. I'm not sure what the issue here with the model. Any tips or advice would be highly appreciated.</P> Wed, 08 Sep 2021 14:17:02 GMT https://community.esri.com/t5/modelbuilder-questions/modelbuilder-output-is-empty/m-p/1096376#M3944 GISLearner 2021-09-08T14:17:02Z https://community.esri.com/t5/modelbuilder-questions/modelbuilder-output-is-empty/m-p/1096417#M3945 <P>possibly look at the field mapping in the spatial join.</P> Wed, 08 Sep 2021 15:03:27 GMT https://community.esri.com/t5/modelbuilder-questions/modelbuilder-output-is-empty/m-p/1096417#M3945 DavidPike 2021-09-08T15:03:27Z https://community.esri.com/t5/modelbuilder-questions/modelbuilder-output-is-empty/m-p/1096424#M3946 <P>The field mapping looks fine. It's pulling in all the columns and they're tied to the correct dataset. To build the model, I ran the entire process manually and then pulled in the tools using history so that the field mapping and other settings are pulled into the model builder tool.</P><P>I was facing issues with the gdb location for the intermediate data so I put in %scratchGDB%. The datasets in the field mapping show up as: C:Users\myuser\AppData\Local\Tmp\ArcGISProTemp###\hashes\scratch.gdb\Properties</P><P>Do you think this could be causing the issue?</P> Wed, 08 Sep 2021 15:20:18 GMT https://community.esri.com/t5/modelbuilder-questions/modelbuilder-output-is-empty/m-p/1096424#M3946 GISLearner 2021-09-08T15:20:18Z https://community.esri.com/t5/modelbuilder-questions/modelbuilder-output-is-empty/m-p/1097856#M3947 <P>Similar issues a couple weeks ago. "Refreshing" the field mapping on the tool(s) fixed the issue for us.</P> Mon, 13 Sep 2021 23:50:34 GMT https://community.esri.com/t5/modelbuilder-questions/modelbuilder-output-is-empty/m-p/1097856#M3947 TonyDeLaRosa 2021-09-13T23:50:34Z https://community.esri.com/t5/modelbuilder-questions/modelbuilder-output-is-empty/m-p/1098036#M3948 <P>When are you refreshing? Every time before you the run the tool? Also, what did you use as the database (output location for intermediate data) in your tools? Thanks!</P> Tue, 14 Sep 2021 13:57:11 GMT https://community.esri.com/t5/modelbuilder-questions/modelbuilder-output-is-empty/m-p/1098036#M3948 GISLearner 2021-09-14T13:57:11Z