Forum Discussion
Issues with mixed-type field
I'm having several issues with a mixed-type field that I've spent hours trying to fix. The first of my issues is that I need a consistent type/fromat ###.###. The second issue is splitting...
Silly question, but have you tried changing the data type to text before doing any transformations?
I assume it's currently showing as 'Any' type to allow both numerical and text types in a single column.
Pete
I did but it didn't work. However, I think I found a solution for that problem and can now try your steps for splitting the items with dashes.
Here's what I did:
Transformation = Table.TransformColumns(#"Reordered Columns",{{"code", each try Number.Round(Decimal.From(_),3) otherwise _}}),
#"Changed Type" = Table.TransformColumnTypes(Transformation,{{"code", type text}})
So with this, so now the 327.001 no longer changes to 327.00099999999998 when I covert it to text. Will report back once I add your steps.
thanks!