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?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.