Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to create QVD from Pl/SQL ?

Need Qlikview Script instead of Pl/sql Script..

20 Replies
nizamsha
Specialist II
Specialist II

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;

Not applicable
Author

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...

Not applicable
Author

What do you need it to actually do ?


Load already stored/queried information, or, something else ?

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

You can drop the unwanted columns by using

drop field/fields statement in script.

Not applicable
Author

Hi Angad,

Can you see the above Script it is having lot of conditions..Can you implement that..

Thanks,

Helen

Not applicable
Author

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

ThornOfCrowns
Specialist II
Specialist II

This isn't what you asked for orginally and the longer the thread goes on, the more confusing it becomes.

Can you state clearly:

  • What you need
  • What you have
  • What you have tried
  • Where it's going wrong
arsal_90
Creator III
Creator III

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.