Forum Discussion
Repetitive Nonbreak space
Hello Community, Now I have a strange problem, in some columns I'm not able to change values type to decimal (1.2) : The problem is the thousands values looks like this "1 000". I thought it is a sp...
Yes, and nothing happens even visually till I copy one value and delete the number and the coma to keep the nonbreak space, at this moment it works, but I want a general approach to apply it to the whole model, not column by column cuz they are numerous.
Wierd. But if I'm undertanding you right you have code that works you just want to avoid the clicks to apply it repeatedly? You can use the unpivot other columns function to put the values in one column, apply your fix, then pivot them back (or skip the last pivot depending how you want to structure your data model).