topic Re: Uploading multiple queries from same source in QlikView

Uploading multiple queries from same source

Thu, 29 Aug 2013 07:22:33 GMT

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?

Re: Uploading multiple queries from same source

ariel_klien — Thu, 29 Aug 2013 07:28:27 GMT

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

Re: Uploading multiple queries from same source

Thu, 29 Aug 2013 07:39:35 GMT

LOAD yourtables

SQL QUERY (SELCET whatever FROM)

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

Re: Uploading multiple queries from same source

Thu, 29 Aug 2013 08:26:49 GMT

Thanks, now I got the result I wanted!

I used:

load*

;

SQL

select "number 1"

;

load*

;

SQL

select "number2"

;

and so on.

Re: Uploading multiple queries from same source

Thu, 29 Aug 2013 08:29:41 GMT

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"

;

Re: Uploading multiple queries from same source

Thu, 29 Aug 2013 08:40:55 GMT

Great, surprisingly easy and useful!