This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi. I am working on a project where i need to do calculations based on physical length measurements. The data i get can consist of three different measurement units (meters, feet, and inches), and there is an arbitrary amount of measurements. The format is
Could you do a find and replace on the unit? (I guess you would need to do this three times, unless you pivoted your data) So if you find an inch, append the value 0.0254, 'meter' => 1, etc. Then multiply by that conversion factor for each of your measurements.
If you provide some dummy data, I can mock something up.
It probably should be noted that there can be different amount of columns. in the mock i have depth, height, width, but a lot of other measurements can be present as well such as length, offset etc. so i feel like it has to be handled dynamically.