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

%3CLINGO-SUB%20id%3D%22lingo-sub-2054049%22%20slang%3D%22en-US%22%3EUnpivot%20Transformation%20Error%3A%20XX%20column%20is%20not%20of%20the%20same%20unpivot%20datatype%20(Data%20flow%20in%20ADF)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2054049%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%20Everyone%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20want%20to%20unpivot%20the%20following%20data%20table%2C%20but%20I%20got%20the%20error%3A%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EKPI1%20column%20is%20not%20of%20the%20same%20unpivot%20datatype%3C%2FSTRONG%3E%3CSPAN%3E.%20I%20checked%20the%20KPI1%20datatype.%20It%20is%20a%20long%20format.%20I%20think%20it%20is%20one%20type%20of%20numerical%20datatypes%20(integer%2C%20decimal%2C%20long%2C%20double%2C%20etc)%2C%20all%20numerical%20columns%20should%20be%20treated%20in%20the%20same%20way.%20Is%20there%20any%20requirement%20for%20datatype%20in%20unpivot%20transformation%2C%20for%20example%20numerical%20columns%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Qianru_Song_0-1610480152527.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F245718i7475A0ADD892D8FB%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Qianru_Song_0-1610480152527.png%22%20alt%3D%22Qianru_Song_0-1610480152527.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThank%20you%20for%20any%20insights%20to%20fix%20the%20error.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2054049%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMapping%20Data%20Flows%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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?

 

Qianru_Song_0-1610480152527.png

Thank you for any insights to fix the error.

0 Replies