https://community.esri.com/t5/arcgis-pro-questions/joinfield-doesn-t-concatenate-the-date-type-fields/m-p/1173877#M55153 <P>I'm using this code to make a join to a SQL Server database view.</P><DIV><DIV><SPAN>arcpy</SPAN><SPAN>.management.MakeQueryTable(</SPAN><SPAN>CEView</SPAN><SPAN>, </SPAN><SPAN>"CE"</SPAN><SPAN>, </SPAN><SPAN>"USE_KEY_FIELDS"</SPAN><SPAN>, </SPAN><SPAN>"SID"</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; </SPAN></DIV></DIV><DIV><DIV><SPAN>arcpy</SPAN><SPAN>.management.JoinField(</SPAN><SPAN>in_data</SPAN><SPAN>=</SPAN><SPAN>mem</SPAN><SPAN>, </SPAN><SPAN>in_field</SPAN><SPAN>=</SPAN><SPAN>"id"</SPAN><SPAN>, </SPAN><SPAN>join_table</SPAN><SPAN>=</SPAN><SPAN>"CE"</SPAN><SPAN>, </SPAN><SPAN>join_field</SPAN><SPAN>=</SPAN><SPAN>"SID"</SPAN><SPAN>, </SPAN><SPAN>fields</SPAN><SPAN>=[</SPAN><SPAN>"SID"</SPAN><SPAN>, </SPAN><SPAN>"ExpirationDate"</SPAN><SPAN>, </SPAN><SPAN>"AnotherDate"</SPAN><SPAN>])</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN><SPAN>Then I use&nbsp;</SPAN></SPAN><SPAN>CopyFeatures to write data back to the SQL Server but i</SPAN><SPAN>t gives me the output with "SID" but other fields&nbsp;"ExpirationDate", "AnotherDate" are not included in the output.</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>This process works if I use a table that includes the same data instead of a view. Is there any workaround for this?</SPAN></DIV></DIV> Fri, 13 May 2022 19:06:08 GMT Anonymous User 2022-05-13T19:06:08Z https://community.esri.com/t5/arcgis-pro-questions/joinfield-doesn-t-concatenate-the-date-type-fields/m-p/1173877#M55153 <P>I'm using this code to make a join to a SQL Server database view.</P><DIV><DIV><SPAN>arcpy</SPAN><SPAN>.management.MakeQueryTable(</SPAN><SPAN>CEView</SPAN><SPAN>, </SPAN><SPAN>"CE"</SPAN><SPAN>, </SPAN><SPAN>"USE_KEY_FIELDS"</SPAN><SPAN>, </SPAN><SPAN>"SID"</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; </SPAN></DIV></DIV><DIV><DIV><SPAN>arcpy</SPAN><SPAN>.management.JoinField(</SPAN><SPAN>in_data</SPAN><SPAN>=</SPAN><SPAN>mem</SPAN><SPAN>, </SPAN><SPAN>in_field</SPAN><SPAN>=</SPAN><SPAN>"id"</SPAN><SPAN>, </SPAN><SPAN>join_table</SPAN><SPAN>=</SPAN><SPAN>"CE"</SPAN><SPAN>, </SPAN><SPAN>join_field</SPAN><SPAN>=</SPAN><SPAN>"SID"</SPAN><SPAN>, </SPAN><SPAN>fields</SPAN><SPAN>=[</SPAN><SPAN>"SID"</SPAN><SPAN>, </SPAN><SPAN>"ExpirationDate"</SPAN><SPAN>, </SPAN><SPAN>"AnotherDate"</SPAN><SPAN>])</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN><SPAN>Then I use&nbsp;</SPAN></SPAN><SPAN>CopyFeatures to write data back to the SQL Server but i</SPAN><SPAN>t gives me the output with "SID" but other fields&nbsp;"ExpirationDate", "AnotherDate" are not included in the output.</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>This process works if I use a table that includes the same data instead of a view. Is there any workaround for this?</SPAN></DIV></DIV> Fri, 13 May 2022 19:06:08 GMT https://community.esri.com/t5/arcgis-pro-questions/joinfield-doesn-t-concatenate-the-date-type-fields/m-p/1173877#M55153 Anonymous User 2022-05-13T19:06:08Z