Forum Discussion
CapnShanty
7 years agoFrequent Visitor
Change row-level data types?
I have a table of MetricName, MetricValue. Some of these metrics are dollars, others are percents. They are all simply stored as numbers. Is there a way to change individual data point data types...
PattemManohar
7 years agoCommunity Champion
CapnShanty Based on my understanding of your scenario, Did you tried having an another table (Symbols) with MetricName and Symbol.... Link this with your main table on MetricName.... then use the Symbol from Symbols table... Kind off like this.....