I'm using derived column transformation editor to remove leading zeroes from the number. Can anyone help me how to do it?
Numeric data imported from Excel does not have leading zeros (after import).
Are you importing the columns as strings?
The absence of evidence is not evidence of absence - Martin Rees The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response - Phil Parkin