how can i make a resident of a qvd

[siddharthsoam]

i have qvd named cease.qvd. In that there is a PnL table.

I am loading the PnL table from the qvd-

load * from [lib://pnl/cease.qvd] (qvd);

Then i want to make a resident table from PnL-

tab2:

Load

"Fiscal Year",

Quarters,

"Customer Group Descr",

SBU_leaders,

If(((sum(EBIDTA)/sum(new_revenue))*100)<0,'<0%',

If(((sum(EBIDTA)/sum(new_revenue))*100)>=0 and (sum(EBIDTA)/sum(new_revenue))*100<10,'0-10%',

If(((sum(EBIDTA)/sum(new_revenue))*100)>=10 and (sum(EBIDTA)/sum(new_revenue))*100<20,'10-20%',

If(((sum(EBIDTA)/sum(new_revenue))*100)>=20,'>=20%','<0%')))) as EBIDTA%_categorization

Resident PNL  //??

Group by "Fiscal Year",Quarters,"Customer Group Descr",SBU_leaders;

If i try making a resident of PnL it is showing me a an error. , how can i make a resident by loading the qvd with the above script.

New to making qvd's, request your help

[Chanty4u]

what error it is showing?

[migueldelval]

What is the name of first table, when you load a "PNL QVD"?

[siddharthsoam]

hi ,

its showing PnL not found

[siddharthsoam]

hi miguel,

The qvd is cease and the table is pnl.

[migueldelval]

Could you attach your script?

[siddharthsoam]

Hi PFA screenshots of the script

[Chanty4u]

instead of *

PnL:

load

Field1,

Field2

Filed3.....

From PNl .qvd

main:

load *,

field1

...

resident   PnL

[migueldelval]

Hi,

I think that you nedd to name your table when you load QVD. If you have another table with the same name, You are going to have problems too.

PNL:

load * from [lib://pnl/cease.qvd] (qvd);

tab2:

Load

"Fiscal Year",

Quarters,

"Customer Group Descr",

SBU_leaders,

If(((sum(EBIDTA)/sum(new_revenue))*100)<0,'<0%',

If(((sum(EBIDTA)/sum(new_revenue))*100)>=0 and (sum(EBIDTA)/sum(new_revenue))*100<10,'0-10%',

If(((sum(EBIDTA)/sum(new_revenue))*100)>=10 and (sum(EBIDTA)/sum(new_revenue))*100<20,'10-20%',

If(((sum(EBIDTA)/sum(new_revenue))*100)>=20,'>=20%','<0%')))) as EBIDTA%_categorization

Resident PNL  //??

Group by "Fiscal Year",Quarters,"Customer Group Descr",SBU_leaders;

Regards

Miguel del Valle

[siddharthsoam]

Hi Miguel/Chanty,

I have 2 different tables having almost the same colmuns being loaded from two different sources which i merged in a single qvd(cease)