Expression

[sona_sa]

Hi Team,

I have attached an excel, I need the expression for the Output.

I have that Actual Data and I need the Output as per my Actual Data HC, DOJ and DOL.

Any Idea on the same, Please share how I can make an expression for the same, So I can get that Output.

First row will be same, Only second row and first column will be change .

Thanks

[Taoufiq_Zarra]

@sona_sa 

in Load you can use this script :

Input:
LOAD * INLINE [
    Fiscal Month, HC, DOJ, DOL
    Apr, 4 559, 122, -69
    May, 4 600, 46, -83
    Jun, 4 619, 19, -64
    Jul, 4 651, 32, -54
    Aug, 4 651, 0, -32
    Sep, 4 636, 0, -14
    Oct, 4 622, 0, -9
    Nov, 4 613, 0, -11
    Dec, 4 602, 0, -9
    Jan, 4 593, 0, -9
    Feb, 4 584, 0, -18
    Mar, 4 566, 0, -13
];


output:
noconcatenate

load [Fiscal Month],if(rowno()=1,HC,peek(Output)+DOJ+DOL) as Output, DOJ, DOL resident Input; 

drop table Input;

output: