Employee id same length

[Thiviya]

Hi,

How do I update the employee id to have the same length as other employee i.e 6 characters ?

[Thiviya]

Is it how should be ?

[Thiviya]

= Table.TransformColumnTypes(AddedCustom,{"Manager ID", each Text.PadStart(Text.From(_),6,"0"}})

[v-jingzhan-msft]

Hi @Thiviya 

It should be Table.TransformColumns rather than Table.TransformColumnTypes. 

[wdx223_Daniel · Accepted solution]

=Table.TransformColumns(PreviousStepName,{"Manager ID",each Text.PadStart(Text.From(_),6,"0")})