Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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';

1 Reply
Employee
Employee

Re: Why doesn't this cmd work?

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