topic How do you add more than 1 table in the script editor ? in QlikView

How do you add more than 1 table in the script editor ?

Mon, 21 Nov 2011 15:58:07 GMT

Example i have this SQL statement which i use to grab my data (and join 4 tables): SQL SELECT * FROM RAMBATHS.AULT2F2.ORDLNORD,RAMBATHS.AULT2F2.PARTS,RAMBATHS.AULT2F2.ORDHDORD,RAMBATHS.AULT2F2.OEP20 where cono40=cono55 and ordn40=ordn55 and cono55=cono35 and catn55=pnum35 and cono55='01' and cono40=cono20 and cusn40=cusn20 and dseq40=dseq20 and Stat55=' ' which is grabbing 4 tables. I need to grab about 30 tables. Or 10 at the least. How in the script editor do you definite more than 1 table when grabbing from an ODBC data source ? Ta Adam

How do you add more than 1 table in the script editor ?

rbecher — Mon, 21 Nov 2011 16:03:02 GMT

Hi Adam,

you have to specify the table name before the SQL SELECT in the script:

mytable1:

SQL SELECT..

mytable2:

SQL SELECT..

etc.

- Ralf

How do you add more than 1 table in the script editor ?

Mon, 21 Nov 2011 16:19:18 GMT

Excellent thank you Ralf looks like i need to get myself some SQL reading material

How do you add more than 1 table in the script editor ?

Mon, 21 Nov 2011 16:51:12 GMT

Ralf if it doesn't automatically pick up the join how do i make it join ?

SQL SELECT * FROM RAMBATHS.AULT2F2.ORDLNORD,RAMBATHS.AULT2F2.PARTS,RAMBATHS.AULT2F2.ORDHDORD,RAMBATHS.AULT2F2.OEP20
where cono40=cono55 and ordn40=ordn55 and cono55=cono35 and catn55=pnum35 and cono55='01' and cono40=cono20 and cusn40=cusn20 and dseq40=dseq20 and Stat55=' '
;

Warehouse:
SQL select * from rambaths.AULT2F2.WHP35

;
Description:
SQL select * from rambaths.aulsprx3.pgmj

Thats the select statements i have, but the file pgmj from the descriptions table has a field called PSAR15 which matches with PGMJ35 from the file PARTS. Because the fields arent the same name Qlikview didnt manage to match them so the file is orphaned. How do i match it ?

Kind Regards

Adam

How do you add more than 1 table in the script editor ?

rbecher — Mon, 21 Nov 2011 16:56:30 GMT

Adam,

it's always better to select a column list instead of star (*). Then you also can use a column alias:

SQL SELECT PSAR15 as PGMJ35 ...

.. or vice versa.

- Ralf

How do you add more than 1 table in the script editor ?

Tue, 22 Nov 2011 09:02:15 GMT

Perfect. Thanks Ralf. I do have 1 last question but i'll slap it in another post