need help

[mshailaja]

Hi

I  am having  table  coming from the database  and loading into the qvd and  storing as extractor qvw, this extractor qvw ( where qvd resides) will use for some other  applications. so i dont want to make calculations on this table .

the  data in the qvd looks like this

Load * inline

[

Duration , id

1,A1

2,D2

3,F5

4,H6

5,J8

.........

567546,UJHY6

];

Now i have to do  3 claculations on backend script level

the 3 calculations are

1)Duration/60 as Durations

2)Sum(Durations) as correctduration

3)(if(correctduration <60,correctduration ,correctduration /60)) as Right Duration

Load2;
LOAD
(if(correctduration <60,correctduration ,correctduration /60)) as Right Duration , id;
Load1:
LOAD
Sum(Durations) as correctduration , id;
LOAD:
LOAD 
Duration/60 as Durations ,
id;

Load * inline

[

Duration , id

1,A1

2,D2

3,F5

4,H6

5,J8

.........

567546,UJHY6

];

While i am trying in the resident load  , i am getting the output, but  the reload time is very high and it is impacting the performance

So i went for preceding lload like the  above script, i am getting the errors.

  My question is  we can do  multiple precedng loads in the same load statement  if means can any one give me the solution for the above?

[avinashelite]

Yes adamdavi3s‌ that s what is was trying to mention we cannot directly use it we would need the Group by clause statement

[mshailaja]

@ Johan , Thanks for the Solution

[puttemans]

Good morning Sailaja,

Glad I could help you with your question. Could you please mark my answer as the correct one, and by doing so close this thead?

Kind regards,

Johan