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 

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

  • acerNZ's avatar
    acerNZ
    Helper III
    5 years ago

    Thank you PhilipTreacy  It is just to concatenate to form full address as the columns were split up ( house, street, region, state, zip code, etc). I was about to to extend the logic of merging queries to a step prior with concatenation as well.  Best Regards