Hi Everyone,
I want to unpivot the following data table, but I got the error: KPI1 column is not of the same unpivot datatype. I checked the KPI1 datatype. It is a long format. I think it is one type of numerical datatypes (integer, decimal, long, double, etc), all numerical columns should be treated in the same way. Is there any requirement for datatype in unpivot transformation, for example numerical columns?
Thank you for any insights to fix the error.