1 Reply Latest reply: Mar 30, 2015 8:41 AM by Michael Tarallo Branched from an earlier discussion. RSS

    Re: Why doesn't this cmd work?

      Ok, let me ask about another issue:

      in the script that I'm including,

      I wrote 2 SQL sentences.

      Qliksense actually imports only the first one.

      What's the syntax to include everything?

       

      Products:

      SQL

      select ITEM AS Code,

      NMPIAN AS Number

      from Articles where Category='WIP';

       

      Description:

      SQL

      select  ITEM AS Code,

      Description

      from DESC where Category='WIP';

        • Re: Why doesn't this cmd work?
          Michael Tarallo

          Hi Gio,

           

          It should look like what I have below using the LOAD statements and both tables will load.

           

          Why are you not using the data selector interface to select your data and to insert the script for you?

           

           

          LOAD CategoryID,

              CategoryName,

              Description;

          SQL SELECT CategoryID,

              CategoryName,

              Description

          FROM GettingStarted.dbo.Categories;

           

          LOAD CustomerID,

              Address,

              City,

              Customer,

              ContactName,

              Country,

              Fax,

              Phone,

              PostalCode;

          SQL SELECT CustomerID,

              Address,

              City,

              Customer,

              ContactName,

              Country,

              Fax,

              Phone,

              PostalCode

          FROM GettingStarted.dbo.Customers;

           

           

          Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

           

          Regards,

          Mike Tarallo

          Qlik