<?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>topic Unable to use use &amp;quot;Concatenate or Join&amp;quot; function in Management &amp; Governance</title>
    <link>https://community.qlik.com/t5/Management-Governance/Unable-to-use-use-quot-Concatenate-or-Join-quot-function/m-p/1793852#M19107</link>
    <description>&lt;P&gt;I am unable to concatenate 2 tables. From the Tables view in the Data Manager tab I click on a table, then select "Concatenate of join" from the bottom of the page (three dots menu).&amp;nbsp; When I select the other table to concatenate, I don't see the menu for concatenating table, instead I just see the message "Select two tables to concatenate or join them".&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;I did notice that there are some 500 errors:&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;api/dataprepservice/v1/apps/abc-123-456/model/current/tables/transformations/recommendation?xrfkey=abc123&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;The response error message is:&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;Unable to lookup the field! Dataset:abcd-1234-efgh, field:abcd-1234-efgh-5678&lt;/LI-CODE&gt;</description>
    <pubDate>Sat, 16 Nov 2024 00:23:23 GMT</pubDate>
    <dc:creator>brian1</dc:creator>
    <dc:date>2024-11-16T00:23:23Z</dc:date>
    <item>
      <title>Unable to use use "Concatenate or Join" function</title>
      <link>https://community.qlik.com/t5/Management-Governance/Unable-to-use-use-quot-Concatenate-or-Join-quot-function/m-p/1793852#M19107</link>
      <description>&lt;P&gt;I am unable to concatenate 2 tables. From the Tables view in the Data Manager tab I click on a table, then select "Concatenate of join" from the bottom of the page (three dots menu).&amp;nbsp; When I select the other table to concatenate, I don't see the menu for concatenating table, instead I just see the message "Select two tables to concatenate or join them".&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;I did notice that there are some 500 errors:&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;api/dataprepservice/v1/apps/abc-123-456/model/current/tables/transformations/recommendation?xrfkey=abc123&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;The response error message is:&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;Unable to lookup the field! Dataset:abcd-1234-efgh, field:abcd-1234-efgh-5678&lt;/LI-CODE&gt;</description>
      <pubDate>Sat, 16 Nov 2024 00:23:23 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Management-Governance/Unable-to-use-use-quot-Concatenate-or-Join-quot-function/m-p/1793852#M19107</guid>
      <dc:creator>brian1</dc:creator>
      <dc:date>2024-11-16T00:23:23Z</dc:date>
    </item>
    <item>
      <title>Re: Unable to use use "Concatenate or Join" function</title>
      <link>https://community.qlik.com/t5/Management-Governance/Unable-to-use-use-quot-Concatenate-or-Join-quot-function/m-p/1794943#M19108</link>
      <description>&lt;P&gt;If you select a table and choose the "Concatenate or Join" option&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Dalton_Ruer_0-1616784643238.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/51923i11AD2E5F622F5CC1/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Dalton_Ruer_0-1616784643238.png" alt="Dalton_Ruer_0-1616784643238.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;You will then need to choose which action to take. I choose Concatenate&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Dalton_Ruer_1-1616784727636.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/51924iD8CF09C6CB1F0E84/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Dalton_Ruer_1-1616784727636.png" alt="Dalton_Ruer_1-1616784727636.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;At the bottom of the screen I am prompted to "Select a second table...."&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Dalton_Ruer_2-1616784771167.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/51925i925C8352790A5891/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Dalton_Ruer_2-1616784771167.png" alt="Dalton_Ruer_2-1616784771167.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;I select my other table and then press Apply&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Dalton_Ruer_3-1616784809238.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/51926i4F245C5376BFEF5D/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Dalton_Ruer_3-1616784809238.png" alt="Dalton_Ruer_3-1616784809238.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The system shows tables that are concatenated with the overlaying circles above the table name&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Dalton_Ruer_4-1616784853118.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/51927i0C730163FFFFAAD9/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Dalton_Ruer_4-1616784853118.png" alt="Dalton_Ruer_4-1616784853118.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;For added fun if you select a table(s) that are concatenated you can press the Split icon to un-concatenate them.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Dalton_Ruer_5-1616784917884.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/51928i0780EFD1C0547A4E/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Dalton_Ruer_5-1616784917884.png" alt="Dalton_Ruer_5-1616784917884.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 26 Mar 2021 18:55:36 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Management-Governance/Unable-to-use-use-quot-Concatenate-or-Join-quot-function/m-p/1794943#M19108</guid>
      <dc:creator>Dalton_Ruer</dc:creator>
      <dc:date>2021-03-26T18:55:36Z</dc:date>
    </item>
  </channel>
</rss>

