I've got several columns that need to be converted using units. For example, I've got a lot of columns with data in meters, but I want to have feet. Also, I've got a lot of columns with tasks duration in a decimal number that must be multiplied by 24 to represent hours.
I would like to have a constant multiplier / conversion factor for each unit type (distance, duration, etc.) and apply it to several columns at once when preparing the data.
Anybody comes with another idea rather than copy&paste the function for each column? Thanks!
Solved! Go to Solution.
Thank you @prateekraina,
I already explored this possibility and I'll still require a lot of work, since I've got +100 columns that need some kind of conversion.
I think I'm looking for a way to "categorize" the columns that doesn't exist yet... It'll be great to be able to create "unit sets" that you can use to automatically convert currencies, measurements, etc...