Table.TransformColumns - Expression.Error: We cannot apply field access to the type Text.

[Radoslaw Poprawski]

Hello,
Ive been having this issue with Table.TransformColumns for a long time:

= Table.TransformColumns(Custom2, {"Invoice number/ Document reference number", each if Text.Middle(_, 0,3) = "ING" then _ & " " & [Invoice Currency]  else _  })

How then, do I access the text hidden in "Invoice Currency" column and merge it with existing text using this specific command

Currently, I'm getting an expression error as if the column name was not recognized.

 

[RoryA]

I don't believe you can refer to another column when using

Table.TransformColumns

.

 

[Radoslaw Poprawski]

Thats why im afreid of.
but if not this code, then how should I change data from my column, without adding new column?

 

[RoryA]

Use Table.ReplaceValue

 

[Radoslaw Poprawski]

Can I ask for example?

 

[EMoscosoCam]

For this example, the formula replaces the text in the column [Name] looking for the text in [Column1] and replacing it with "*":

= Table.ReplaceValue(PreviousStepTable, each _[Column1], "*", Replacer.ReplaceText, {"Name"}),