Discussion board where members can get started with Qlik Sense.
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???
Are you using a preceding LOAD after the SQL statement?
SQL SELECT * FROM Your_Table;
This is how I have it laid out:
COL1, COL2, COL3, COL4
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...
Could be done in data load editor.
How do I adjust relationships in the data load editor?