Use custom SQL in Add Data?

[#1]

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???

[sinanozdemir]

Hi,

Are you using a preceding LOAD after the SQL statement?

LOAD

     *;

SQL SELECT * FROM Your_Table;

[#3]

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...

[Anonymous]

Could be done in data load editor.

[#5]

How do I adjust relationships in the data load editor?