This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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?