Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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);
You posted an excel file with size logs? You want to sum the sizes of MB and GB?
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);