Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
How do I update the employee id to have the same length as other employee i.e 6 characters ?
Solved! Go to Solution.
=Table.TransformColumns(PreviousStepName,{"Manager ID",each Text.PadStart(Text.From(_),6,"0")})
Is it how should be ?
= Table.TransformColumnTypes(AddedCustom,{"Manager ID", each Text.PadStart(Text.From(_),6,"0"}})
=Table.TransformColumns(PreviousStepName,{"Manager ID",each Text.PadStart(Text.From(_),6,"0")})