Script from Query

[Mahamed_Qlik]

Hi 

How would I qliksense script for below query:

select count( Prod_id), PROD_DESC

from ProductTable1 A, ProductTable2 B, ProductTable3 C

where  to_char(a.Prod_id) = b.REQUEST_NUMBER

AND c.STEP_CODE = b.STEP_CODE

and HIST_PROCESS_ID= select max (HIST_PROCESS_ID) from ProductTable2  

where PROCESS_ID = b.PROCESS_ID)

GROUP by PROD_DESC;

[anat]

you can execute the same SQL query in Qlik.

or 

Table:
select Prod_id, PROD_DESC

from ProductTable1 A, ProductTable2 B, ProductTable3 C

where to_char(a.Prod_id) = b.REQUEST_NUMBER

AND c.STEP_CODE = b.STEP_CODE

and HIST_PROCESS_ID= select max (HIST_PROCESS_ID) from ProductTable2

where PROCESS_ID = b.PROCESS_ID);
noconcatenate
Table1:
load count(Prod_id), PROD_DESC resident Table group by PROD_DESC;
drop table Table;

[vinieme12]

there is no concept of querying multiple tables in the same load statement like databases; you can just use the same query to load the data from database into qlik

Please provide more context on what you are tying to do here

ODBC connect to ....;

TableName:

SQL select count( Prod_id), PROD_DESC

from ProductTable1 A, ProductTable2 B, ProductTable3 C

where  to_char(a.Prod_id) = b.REQUEST_NUMBER

AND c.STEP_CODE = b.STEP_CODE

and HIST_PROCESS_ID= select max (HIST_PROCESS_ID) from ProductTable2  

where PROCESS_ID = b.PROCESS_ID)

GROUP by PROD_DESC;

Disconnect;