Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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
Not applicable

Re: Use custom SQL in Add Data?

Hi,

Are you using a preceding LOAD after the SQL statement?

LOAD

     *;

SQL SELECT * FROM Your_Table;

Not applicable

Re: Use custom SQL in Add Data?

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
Not applicable

Re: Use custom SQL in Add Data?

Could be done in data load editor.

Not applicable

Re: Use custom SQL in Add Data?

How do I adjust relationships in the data load editor?