Forum Discussion
Solved
Employee id same length
Hi,
How do I update the employee id to have the same length as other employee i.e 6 characters ?
=Table.TransformColumns(PreviousStepName,{"Manager ID",each Text.PadStart(Text.From(_),6,"0")})
4 Replies
=Table.TransformColumns(PreviousStepName,{"Manager ID",each Text.PadStart(Text.From(_),6,"0")})
= Table.TransformColumnTypes(AddedCustom,{"Manager ID", each Text.PadStart(Text.From(_),6,"0"}})
Is it how should be ?
