Unpivot Transformation Error: XX column is not of the same unpivot datatype (Data flow in ADF)

Question

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.

Thank you for any insights to fix the error.

Answer 1

Finally, I fixed it by changing the datatypes of other numerical columns.

If you have multiple numerical datatypes, it is hard to define the datatype of the new numerical unpivoted column.