Conversion of data

I have a daily backup related data. Please guide me to convert the values under column name "Data written" from size in TB/GB/MB/KB to a separate column and in only bytes.

Actually I wanted to sum all the values under "Data written" but values are in different size.

Tips and Tricks

Accepted answers

EN6924

Hi,

Thanks for guiding me.

I already did it but that doesn't looks perfect to me.

1. I split the column into 2 parts.

2. Then created added a formula tool -

Found result -

3. Added a summarize tool and formula tool (convert the size from bytes to GB & TB)

All comments

r_manju02

Hi,

You can create a lookup table for the byte values after parsing the data written column and use it in your solution (refer the attached workflow).

Size Convert.yxmd

binu_acs

@EN6924 another option using formula tool

Spoiler

EN6924

Hi,

Thanks for guiding me.

I already did it but that doesn't looks perfect to me.

1. I split the column into 2 parts.

2. Then created added a formula tool -

Found result -

3. Added a summarize tool and formula tool (convert the size from bytes to GB & TB)

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

hhaigh1 280