Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello ,
I have COL1, COL2, COL3 & Total as the columns.
Total is the sum of COL1,COL2, COL3.
I have all the above columns in excel. I wanted to make sure that the Total is caluclated correctly.
I use the load script having COL1, COL2,COL3 and Total but not sure how to create a variable and calculate Vtotal =COl1+COL2+COL3
and then create another variable called VDiff to subtract Total -Vtotal .
I want to see COL1,COL2, COL3, TOTAL , VTOTAL and VDiff in Table Box.
Can you help me
Regards,
Paul
You want to create a calculated field in the LOAD statement, right? (I wouldn't call it variable then, because this has a different meaning in QV scripting and QV frontend)
Maybe something along these lines:
LOAD COL1,
COL2,
COL3,
TOTAL,
Rangesum(COL1, COL2, COL3) as VTOTAL;
FROM Excel.xls;
You can even calculate the difference in the script, like
LOAD *,
TOTAL - VTOTAL as DIFF;
LOAD COL1,
COL2,
COL3,
TOTAL,
Rangesum(COL1, COL2, COL3) as VTOTAL;
FROM Excel.xls;
I use a preceding LOAD here to add a calculated field that itself uses a calculated field in the first, bottom LOAD statement.
thank you . Tbe more precise, I have the following columns
Exposure
Collaterals
RiskWt_PCT
CalRW
All the above fields are already there in my csv file. I want to usie load script and also calculate the below variable in the load script and show them in Table Box.
What i want to do is first check if the CalRW is calculated correctly.
So i want to create a variable VCalRW and calculate it as VCalRW = Risk_PCT*(Exposure-Collateral)
Now i also want to create another variable VDiff to calculate CalRW - VCalRW.
I want to see Exposure, Collateral,RiskWT_PCT,CalRW, VCalRW and VDiff in the Table box
Should be quite similar to above:
LOAD *,
CalRW- VCalRW as VDiff;
LOAD Exposure,
Collaterals,
RiskWt_PCT,
CalRW,
RiskWt_PCT*(Exposure-Collaterals) as VCalRW;
FROM ...;
Thank you Swuehi for all the help.
Regards,
Paul