Formatting data of different datatypes in a single table column

kd1985

Hi All,

 

I have a requirement where I need to show a pivot view of data of different datatypes (such as - Currency, Percentage and Numbers) in a single column to show various metrics in a single consolidated view.

 

Any idea on how to achieve this?

 

Thanks.

Msan

Hi,

 

I think this is achievable.  You just need either MySQL or ETL to append data into a single column.