Incorrect UnPivot metadata

Hi

When using unpivot transformation, what exactly this error denote

"Incorrect UnPivot metadata. In an UnPivot transform, all input columns with a PivotKeyValue that is set, and are pointing to the same DestinationColumn, must have metadata that exactly matches "

data on which i was trying unpivoting is -

Name

Pd1

Pd2

Pd3

Pd4

Utsav

111

211

311

411

Verma

122

222

322

422

Nucleus

133

233

333

433

Noida

144

244

344

444

Assume in your scenario, "Name" is set as a pass-thru column, and all other 4 columns point to a same destination column

Then the error suggests that you don't have the same exact datatype on Pd1, Pd2, Pd3, Pd4 (they need to be all I4, or all I2...etc)

Thanks

Wenyang