Forum Discussion

acerNZ's avatar
acerNZ
Helper III
5 years ago
Solved

Multiple queries on custom column ?

Hi Experts, Sorry if the subject is misleading I have a custom column with the following  Step1: = Table.TransformColumnTypes(#"Added Custom",{{"Postcode", type text}})   The out is basically po...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi acerNZ 

    Why the need to do it as 1 step?  Just curious.

    Try this

     

    = Table.ReplaceValue(Table.TransformColumnTypes(#"Added Custom",{{"Postcode", type text}}),",","",Replacer.ReplaceText,{"Full Address"})

     

    regards

    Phil

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi acerNZ 

So did my code work for you?

regards

Phil

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.