Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Use custom SQL in Add Data?

I want to just paste an SQL script into the Add Data area.

I don't want to go picking a bunch of tables by hand, I just want to paste in my query.

I can do that in the LOAD script area...but if I do that I can't manipulate table relationships etc... in the add data area (associations) or whatever.

Is there not anyway to just paste a query into the tool and have it use that result?

Am I forced to create views on my SQL server and then map to the views in Add Data???

4 Replies
sinanozdemir
Specialist III
Specialist III

Hi,

Are you using a preceding LOAD after the SQL statement?

LOAD

     *;

SQL SELECT * FROM Your_Table;

Not applicable
Author

This is how I have it laid out:

COMPANY_DEPARTMENTS:

LOAD *;

SELECT

        COL1, COL2, COL3, COL4

    FROM

        SOME_TABLE

;




However, when I do that I can't manipulate it in the ADD DATA area, and I can't adjust columns the tool picks to join tables on, etc...

datalakeyu
Specialist
Specialist

Could be done in data load editor.

Not applicable
Author

How do I adjust relationships in the data load editor?