Forum Discussion
Solved
Dynamic Datatype from Text to Number conversion is different Localization per Row
Hello there,i have a power query which is updating excel files placed within a specific folder. The layout of these files is always identical - therefor i can easily set the appropriate steps neeed ...
assume all the values in this column is integer, then try this code
NewStep=Table.TransformColumns(PreviousStepName,{"Quantity",each let a=Text.SplitAny(_,".,") in Number.From(Text.Combine(a))/(if Text.Length(List.Last(a))=2 then 100 else 1)})
Hi padinator ,
Any updates? Does wdx223_Daniel 's method help you?
Please Accept a helpful reply as the solution to make this thread closed. Other members could find it more quickly.
Best Regards,
Eyelyn Qin