Uploading multiple queries from same source

[#1]

Hi,

I have used QV for a few weeks and tried to find a way to upload multiple SQL queries from the same database. What I want to do is populate QV with five different queries in one script and end up with five different tables that are not joined in any way.

How can I do this in one script?

[ariel_klien]

hi,

you have many options:

1) use concatenate

2) use Join

3) in the script (select) change the key fields to the same name in all the tables.

i hope that will help you.

BR.

Ariel

[#3]

LOAD yourtables

SQL QUERY (SELCET whatever FROM)

If you have same names somewhere, then use qualify*;

[#4]

Thanks, now I got the result I wanted!

I used:

load*

;

SQL

select "number 1"

;

load*

;

SQL

select "number2"

;

and so on.

[#5]

A good idea is to give ur load a name, if they all come form same source

eg:

Table1:

load*

;

SQL

select "number 1"

Table2:

load*

;

SQL

select "number2"

;

[#6]

Great, surprisingly easy and useful!