Forum Discussion

Thiviya's avatar
Thiviya
Frequent Visitor
2 years ago
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 ?  
  • wdx223_Daniel's avatar
    2 years ago

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