Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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;
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;