Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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???
Hi,
Are you using a preceding LOAD after the SQL statement?
LOAD
*;
SQL SELECT * FROM Your_Table;
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...
Could be done in data load editor.
How do I adjust relationships in the data load editor?