Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts.
Please help on below data.my extracted data is combination of m/s^2,
Here. i need to calculate this m/s values multiplied with 18/5 and the km/h should be multiplied with 1.
Struking with splitting the values and calculations.
Please see the attached and hope this helps:
Please see the attached and hope this helps:
Dear Suman,
You can use the below edit script.
LOAD *,
If(CleanedValues<10, (CleanedValues)*18/5, CleanedValues*1) as Calculateddata;
T1:
LOAD ExistValues,
//CleanedValues,
//Calculateddata,
subfield(PurgeChar(PurgeChar( PurgeChar(PurgeChar(ExistValues,' Acceleration forward or braking:'),' Max Speed:'),' km/h'),' Acceleration side to side:'),'^',1) AS CleanedValues
FROM
(ooxml, embedded labels, table is Sheet1);
Its simple and more helpful for everyone.
Thank you.