Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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';
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