Turn Add Column from examples into Table.TransformColumns

[NAOS]

Hi all,

A little challenge for the weekend. I want to turn a "Add column from examples" code into a "table.transformcolumns" line.

The following is the step I want to replicate but without having to create a new column, instead, I want to apply the same to the "Title" column.

#"Added Custom Column" = Table.AddColumn(FormatUserNames, "Custom", each let splitTitle = List.Reverse(Splitter.SplitTextByDelimiter(", ", QuoteStyle.None)([Title])) in Text.Combine(splitTitle, " "), type text)

What that line of code is doing is turning string from the format "Surname, FirstName" into "FirstName Surname".

Anyone up to solve it?

Thanks!!

[ImkeF · Accepted solution]

This would be the syntax:

Table.TransformColumns(FormatUserNames, {{"Title", each let splitTitle = List.Reverse(Splitter.SplitTextByDelimiter(", ", QuoteStyle.None)(_)) in Text.Combine(splitTitle, " "), type text}})

Please note that the column reference [Title] in your original formula is replaced by an underscore (_) here.

[NAOS]

Spot on! Thanks a lot @ImkeF !