https://community.esri.com/t5/python-questions/addjoin-not-join-layer-and-table-in-toolbox-script/m-p/1360562#M69408 <P>I have a model that runs a script I get an error that states a field does not exist. Once the join happens they filed should exist, and looking at the outputs the join doesn't happend. I can run the stand alone script and also run the model and it runs fine.&nbsp; When run the model in Pro scheduler I run into is issue. I have tried adding a a <A href="https://pro.arcgis.com/en/pro-app/3.0/arcpy/geoprocessing_and_python/setting-script-tool-parameters.htm#GUID-59C4A61C-AC33-4BA3-8453-AC8328E34453" target="_blank" rel="noopener nofollow noreferrer">derived output parameter</A> and still no launch when I run it out of Pro Scheduler.</P><LI-CODE lang="c">join = arcpy.AddJoin_management("Lyr1","ACC_ID",table1, "ACC_ID", "KEEP_COMMON") arcpy.SetParameterAsText(1,join) arcpy.FeatureClassToFeatureClass_conversion("Lyr1", "C:/Temp/test.gdb", "BP_TestA")</LI-CODE><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2023-12-13 12_56_59-Window.png" style="width: 510px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/88953iAA326C0238E13ECE/image-size/large?v=v2&amp;px=999" role="button" title="2023-12-13 12_56_59-Window.png" alt="2023-12-13 12_56_59-Window.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2023-12-13 12_57_13-Window.png" style="width: 597px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/88954i56353F128061FA98/image-size/large?v=v2&amp;px=999" role="button" title="2023-12-13 12_57_13-Window.png" alt="2023-12-13 12_57_13-Window.png" /></span></P> Wed, 13 Dec 2023 20:00:02 GMT TonyAlmeida 2023-12-13T20:00:02Z https://community.esri.com/t5/python-questions/addjoin-not-join-layer-and-table-in-toolbox-script/m-p/1360562#M69408 <P>I have a model that runs a script I get an error that states a field does not exist. Once the join happens they filed should exist, and looking at the outputs the join doesn't happend. I can run the stand alone script and also run the model and it runs fine.&nbsp; When run the model in Pro scheduler I run into is issue. I have tried adding a a <A href="https://pro.arcgis.com/en/pro-app/3.0/arcpy/geoprocessing_and_python/setting-script-tool-parameters.htm#GUID-59C4A61C-AC33-4BA3-8453-AC8328E34453" target="_blank" rel="noopener nofollow noreferrer">derived output parameter</A> and still no launch when I run it out of Pro Scheduler.</P><LI-CODE lang="c">join = arcpy.AddJoin_management("Lyr1","ACC_ID",table1, "ACC_ID", "KEEP_COMMON") arcpy.SetParameterAsText(1,join) arcpy.FeatureClassToFeatureClass_conversion("Lyr1", "C:/Temp/test.gdb", "BP_TestA")</LI-CODE><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2023-12-13 12_56_59-Window.png" style="width: 510px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/88953iAA326C0238E13ECE/image-size/large?v=v2&amp;px=999" role="button" title="2023-12-13 12_56_59-Window.png" alt="2023-12-13 12_56_59-Window.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2023-12-13 12_57_13-Window.png" style="width: 597px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/88954i56353F128061FA98/image-size/large?v=v2&amp;px=999" role="button" title="2023-12-13 12_57_13-Window.png" alt="2023-12-13 12_57_13-Window.png" /></span></P> Wed, 13 Dec 2023 20:00:02 GMT https://community.esri.com/t5/python-questions/addjoin-not-join-layer-and-table-in-toolbox-script/m-p/1360562#M69408 TonyAlmeida 2023-12-13T20:00:02Z https://community.esri.com/t5/python-questions/addjoin-not-join-layer-and-table-in-toolbox-script/m-p/1362132#M69437 <P>Couldn't figure out why this happened, I ended up using arcpy.management.JoinField instead of arcpy.AddJoin_management. Also, I didn't have to use a derived output parameter once I used the arcpy.management.JoinField.</P> Mon, 18 Dec 2023 18:04:52 GMT https://community.esri.com/t5/python-questions/addjoin-not-join-layer-and-table-in-toolbox-script/m-p/1362132#M69437 TonyAlmeida 2023-12-18T18:04:52Z