<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>idea Arcade Documentation: Joined Tables in Developers Ideas</title>
    <link>https://community.esri.com/t5/developers-ideas/arcade-documentation-joined-tables/idi-p/1151331</link>
    <description>&lt;P&gt;&lt;BR /&gt;Could Esri consider improving the Arcade developer documentation on joined tables?&lt;/P&gt;&lt;P&gt;&lt;A href="https://developers.arcgis.com/arcade/guide/faq/#how-do-i-reference-data-from-a-joined-table" target="_self" rel="nofollow noopener noreferrer"&gt;How do I reference data from a joined table?&lt;/A&gt;&lt;/P&gt;&lt;BLOCKQUOTE&gt;&lt;P&gt;You can reference attribute data from a joined table using the square bracket syntax for referencing field names:&amp;nbsp; $feature["&lt;STRONG&gt;joinKey&lt;/STRONG&gt;.fieldName"].&lt;/P&gt;&lt;PRE&gt;&lt;SPAN class=""&gt;// data from a joined table&lt;/SPAN&gt;
&lt;SPAN class=""&gt;var&lt;/SPAN&gt; demVotes2016 = &lt;SPAN class=""&gt;$feature&lt;/SPAN&gt;[&lt;SPAN class=""&gt;"COUNTY_ID.VOTED_DEM_2016"&lt;/SPAN&gt;];
&lt;SPAN class=""&gt;var&lt;/SPAN&gt; demVotes2012 = &lt;SPAN class=""&gt;$feature&lt;/SPAN&gt;[&lt;SPAN class=""&gt;"COUNTY_ID.VOTED_DEM_2012"&lt;/SPAN&gt;];

&lt;SPAN class=""&gt;// returns % change in votes from 2012 to 2016&lt;/SPAN&gt;
&lt;SPAN class=""&gt;Round&lt;/SPAN&gt;( ( ( demVotes2016 - demVotes2012 ) / demVotes2012 ) * &lt;SPAN class=""&gt;100&lt;/SPAN&gt;, &lt;SPAN class=""&gt;2&lt;/SPAN&gt;);&lt;/PRE&gt;&lt;/BLOCKQUOTE&gt;&lt;P&gt;That blurb seems misleading.&amp;nbsp;&lt;/P&gt;&lt;P&gt;More info here:&amp;nbsp;&lt;A href="https://community.esri.com/t5/arcgis-pro-questions/arcade-joined-tables-joinkey/m-p/1151278/highlight/true#M52460" target="_self"&gt;Arcade joined tables: joinKey&lt;/A&gt;&lt;/P&gt;&lt;P&gt;Thanks.&lt;/P&gt;</description>
    <pubDate>Mon, 07 Mar 2022 16:37:43 GMT</pubDate>
    <dc:creator>Bud</dc:creator>
    <dc:date>2022-03-07T16:37:43Z</dc:date>
    <item>
      <title>Arcade Documentation: Joined Tables</title>
      <link>https://community.esri.com/t5/developers-ideas/arcade-documentation-joined-tables/idi-p/1151331</link>
      <description>&lt;P&gt;&lt;BR /&gt;Could Esri consider improving the Arcade developer documentation on joined tables?&lt;/P&gt;&lt;P&gt;&lt;A href="https://developers.arcgis.com/arcade/guide/faq/#how-do-i-reference-data-from-a-joined-table" target="_self" rel="nofollow noopener noreferrer"&gt;How do I reference data from a joined table?&lt;/A&gt;&lt;/P&gt;&lt;BLOCKQUOTE&gt;&lt;P&gt;You can reference attribute data from a joined table using the square bracket syntax for referencing field names:&amp;nbsp; $feature["&lt;STRONG&gt;joinKey&lt;/STRONG&gt;.fieldName"].&lt;/P&gt;&lt;PRE&gt;&lt;SPAN class=""&gt;// data from a joined table&lt;/SPAN&gt;
&lt;SPAN class=""&gt;var&lt;/SPAN&gt; demVotes2016 = &lt;SPAN class=""&gt;$feature&lt;/SPAN&gt;[&lt;SPAN class=""&gt;"COUNTY_ID.VOTED_DEM_2016"&lt;/SPAN&gt;];
&lt;SPAN class=""&gt;var&lt;/SPAN&gt; demVotes2012 = &lt;SPAN class=""&gt;$feature&lt;/SPAN&gt;[&lt;SPAN class=""&gt;"COUNTY_ID.VOTED_DEM_2012"&lt;/SPAN&gt;];

&lt;SPAN class=""&gt;// returns % change in votes from 2012 to 2016&lt;/SPAN&gt;
&lt;SPAN class=""&gt;Round&lt;/SPAN&gt;( ( ( demVotes2016 - demVotes2012 ) / demVotes2012 ) * &lt;SPAN class=""&gt;100&lt;/SPAN&gt;, &lt;SPAN class=""&gt;2&lt;/SPAN&gt;);&lt;/PRE&gt;&lt;/BLOCKQUOTE&gt;&lt;P&gt;That blurb seems misleading.&amp;nbsp;&lt;/P&gt;&lt;P&gt;More info here:&amp;nbsp;&lt;A href="https://community.esri.com/t5/arcgis-pro-questions/arcade-joined-tables-joinkey/m-p/1151278/highlight/true#M52460" target="_self"&gt;Arcade joined tables: joinKey&lt;/A&gt;&lt;/P&gt;&lt;P&gt;Thanks.&lt;/P&gt;</description>
      <pubDate>Mon, 07 Mar 2022 16:37:43 GMT</pubDate>
      <guid>https://community.esri.com/t5/developers-ideas/arcade-documentation-joined-tables/idi-p/1151331</guid>
      <dc:creator>Bud</dc:creator>
      <dc:date>2022-03-07T16:37:43Z</dc:date>
    </item>
    <item>
      <title>Re: Arcade Documentation: Joined Tables</title>
      <link>https://community.esri.com/t5/developers-ideas/arcade-documentation-joined-tables/idc-p/1153900#M1118</link>
      <description>&lt;P&gt;Hi. Thanks for reaching out. Yes, we can improve this. It looks like you specifically refer to the "joinKey", which should be the table name. We can update this in our next documentation update.&lt;/P&gt;</description>
      <pubDate>Tue, 15 Mar 2022 16:51:14 GMT</pubDate>
      <guid>https://community.esri.com/t5/developers-ideas/arcade-documentation-joined-tables/idc-p/1153900#M1118</guid>
      <dc:creator>KristianEkenes</dc:creator>
      <dc:date>2022-03-15T16:51:14Z</dc:date>
    </item>
  </channel>
</rss>

