sum

[deepakqlikview_123]

Hi All,

My data is in below format but I am not able to make sum for this.

Can you please suggest how to make sum for this.

Thanks,

[senpradip007]

Try this:

Load

A,
SubField(B,' ',1) AS Size1,
SubField(B,' ',2) AS Unit1,
SubField(C,' ',1) AS Size2,
SubField(C,' ',2) AS Unit2,
B,
C
FROM
Book1.xlsx
(ooxml, no labels, table is Sheet1);

[#3]

You posted an excel file with size logs?  You want to sum the sizes of MB and GB?

[its_anandrjs]

You can load your table this way also

LOAD A,

     B,

     KeepChar(B,.0123456789) as NewBValue,

     Right(B,2) as Unit,    

     C  

     KeepChar(C,.0123456789) as NewCValue,

FROM

Book1.xlsx

(ooxml, no labels, table is Sheet1);