How to clean simple hourly data

Hey!

Thanks in advance for any help I receive!

I have what I believe is a simple request. Would really appreciate some guidance.

I have an excel of days like this photo.

Basically, I want it to clean the data for incorrect submissions like the one on day 3, 1..0 is an incorrect submission and I want Alteryx to find it and replace it with 1.0

Any ideas?

Help

Accepted answers

RolandSchubert

Hi @lukemanderson12 ,

I've added a second Multi-Field Formula tool with the formula to cut off the last character, if it's a '.'. It would be possible to do it within one formula, but I think my approach is better readable.

Best,

Roland

Replace.yxmd

All comments

lukemanderson12

Tried to use imputation but I think there's too many possibilities and doing all of them would be inefficient.

lukemanderson12

I think I fixed it using select and changing the data to double.

Any other alternatives or will this generally fix it?

lukemanderson12

This solution didn't work, I realized it removes the decimal completely.

I.e "8..5" turns into 8 not 8.5 which is what I need

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703