5 Replies Latest reply: Dec 19, 2017 2:07 PM by Tatsiana Chetirbok RSS

    Automatic Concatenate Not Working

    Derek Emlet

      Why wont these tables auto-concatenate? For example Closed_By1 should concatenate with Closed_By2.

       

      QlikSense Auto Concatenate Criteria --

      "If the field names and the number of fields of two or more loaded tables are exactly the same, Qlik Sense will automatically concatenate the content of the different statements into one table."


      Capture.PNG

       

       

       

       

      UPDATE 12/19/2017:


      I also needed to turn on "Custom" in my REST Connection settings. This was creating a new set of __Key_results each pagination loop...

       

       

      -Derek

       

      Message was edited by: Derek Emlet

        • Re: Automatic Concatenate Not Working
          Bill Markham

          Don't know, but I usually force concatenation in the script rather than rely on auto concatenation as it makes the script more obvious when being looked at.

           

          Maybe a forced concatenation will sort you.

            • Re: Automatic Concatenate Not Working
              Derek Emlet

              Thanks for reply,

               

              Do you know if there is a way to force concatenate AFTER the Load statements?  I am doing an INNER Join between two tables, so if I concatenate the one table before the INNER JOIN, it wont work correctly.

               

              For Example in my script I'm mapping the Username to the Resolved_byID for this one load.


              SQL WITH CONNECT

              //data//


              [Resolved_By1]:

              LOAD

              sys_id AS resolved_by_id,

              name AS Resolved_By

              RESIDENT SU.RestConnectorMasterTable;

               

              [resolved_by1]:

              Inner JOIN (Resolved_By1)

              LOAD

              [value] AS [resolved_by_id],

              [__FK_resolved_by] AS [INC.__KEY_result]

              RESIDENT INC.RestConnectorMasterTable

              WHERE NOT IsNull([__FK_resolved_by]);

               

              ///more load statements here// then another

              SQL WITH CONNECT

              [Resolved_By2]:

              LOAD

              sys_id AS resolved_by_id,

              name AS Resolved_By

              RESIDENT SU.RestConnectorMasterTable;

               

              [resolved_by2]:

              Inner JOIN (Resolved_By2)

              LOAD

              [value] AS [resolved_by_id],

              [__FK_resolved_by] AS [INC.__KEY_result]

              RESIDENT INC.RestConnectorMasterTable

              WHERE NOT IsNull([__FK_resolved_by]);

               

               

              Thanks for the help.

            • Re: Automatic Concatenate Not Working
              wassim ben gamra

              Hi Derek, remove the table labels for the seconds tables.