Power Query - Table. Tranformcolumns

Maya Lin-Takahashi
Maya Lin-Takahashi
• • 2 min read

I'm Trying to Add Leading Zeros into a Column in Power Query Call Jobcodes. I Know I Can Do This by Adding a New Column Using Text. Start([Jobcodes],5,"0")...

Power Query - Table. Tranformcolumns

I'm trying to add leading zeros into a column in power query call JobCodes. I know I can do this by adding a new column using Text.Start([JobCodes],5,"0"), but I don't want to add a new column and go back to remove the column I don't need. I want to be able to do this in one step using Table.TransformColumns function. Is this possible?

Code:

Table.TransformColumns(#"Changed Type", each Text.PadStart([JobCodes],5,"0"))

Must Read

Error:

Expression.Error: We cannot convert a value of type Function to type List. Details: Value=Function Type=Type

1
Maya Lin-Takahashi

Maya Lin-Takahashi

Consumer Tech & Gadget Reviewer
Youtube Instagram Twitter

Maya is a hardware enthusiast who tests and reviews smart home devices, smartphones, wearables, and audio gear. She focuses on practical consumer value and build quality.