Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Need Qlikview Script instead of Pl/sql Script..
Hi,
Execute your pl/sql procedure or function from your qlikview script.
Your pl/sql procedure should return some result set. In case of function it will return some result set. In case of procedure to return values use ref cursor.
like
connection_string_to_database
Table1:(Qlikview_Sample_Table)
sql
exec sample_procedure;
store Table1 into Table1.qvd;
I am having the script of PL/sql and related QVds involved for that script..
I have to convert that into qvscript...
help me on this...
What do you need it to actually do ?
Load already stored/queried information, or, something else ?
ok, to start with , use the below:
Since GSI_REVENUE_CODE_ID is common in both, the left join() will join both the table on the common field name.
Now this will be similar to
DB Query:
SELECT rd.GSI_REVENUE_CODE_ID, rd.PRODUCT_CODE, rd.PROFIT_CENTER, rd.DUNNING_AREA, rd.COST_CENTER
FROM GSI_PRODUCT_REVENUE_MAP prm, GSI_REVENUE_DET rd
WHERE prm.GSI_REVENUE_CODE_ID=rd.GSI_REVENUE_CODE_ID
QVScript:
GSI_PRODUCT_REVENUE_MAP_tbl:
LOAD
GSI_REVENUE_CODE_ID,
PRODUCT_ATTR_SEG,
PRODUCT_ID,
CHARGE_TYPE,
CUSTOMER_TYPE_ID
..\QVDLocation\GSI_PRODUCT_REVENUE_MAP.qvd
GSI_REVENUE_DET_tbl:
left join(GSI_PRODUCT_REVENUE_MAP_tbl)
LOAD
GSI_REVENUE_CODE_ID,
PRODUCT_CODE,
PROFIT_CENTER,
DUNNING_AREA,
COST_CENTER
..\QVDLocation\GSI_REVENUE_DET.qvd
You can gradually expand the query step by step.
Hope this was helpful.
Thanks,
Angad
In all SQL stmts, I want to display only these columns , no need of extra columns..
GSI_REVENUE_CODE_ID,
PRODUCT_CODE,
PROFIT_CENTER,
DUNNING_AREA,
COST_CENTER
You can drop the unwanted columns by using
drop field/fields statement in script.
Hi Angad,
Can you see the above Script it is having lot of conditions..Can you implement that..
Thanks,
Helen
As I earlier said,
To transform your query into a QV Script, we would require
>> Knowledge of the whole data model of the application.
>> Understand what exactly the query is doing.
Did you start breaking the query into smaller pieces and tranforming it?
I would suggest you should try doing it by yourself, and let the community know, where you get stuck.
Hope this was helpful.
Thanks,
Angad
This isn't what you asked for orginally and the longer the thread goes on, the more confusing it becomes.
Can you state clearly:
Please upload the sample data file and also share the query that u want to translate in qv script and what is the desired result u want from them also share it.