Forum Discussion

Robin96's avatar
Robin96
Helper II
3 years ago
Solved

Clean address column

Hey all, Is there a way to clean the customer address field? i have imported a CSV file. There are different ways the customer writes their addresses, here are some examples:   i want the ...
Need Help
  • davehus's avatar
    davehus
    3 years ago

    Hi Robin96 ,

     

    The first bit would be to try and standardise the incoming address from the customer if possible. You can use a conditional column in powerquery to work through your column and clean it into a new column but I don't know how intensive that might be in terms of the data etc based on your example.

     

    Hope this helps.

     

    Did I help you today? Please accept my solution and hit the Kudos button.

davehus's avatar
davehus
Memorable Member
3 years ago

Hi Robin96 ,

 

The first bit would be to try and standardise the incoming address from the customer if possible. You can use a conditional column in powerquery to work through your column and clean it into a new column but I don't know how intensive that might be in terms of the data etc based on your example.

 

Hope this helps.

 

Did I help you today? Please accept my solution and hit the Kudos button.

Robin96's avatar
Robin96
Helper II
3 years ago

Hey, davehus 

Thanks for the reply. there is unfortunately no way to standardise the incoming data as its data from Shopify Checkout. Guess i'll have to shape the data somewhere else then the power query editor.