Forum Discussion

awtahhan's avatar
awtahhan
Regular Visitor
5 years ago
Solved

Replace column values using Uri.parts function

Hello,   I have a column with encoded URL values, I want to decode and replace these values using Uri.parts function, to do so I constructed the following poqwer query:   Table.ReplaceValue(#"Ren...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi awtahhan 

     

    Download example PBIX file

     

    The initial error you posted stated We cannot convert a value of type List to type Text. so I expected that your url column contains Lists somewhere like this

     

    To avoid that error you can use try..otherwise when creating your Custom Column in Power Query like this

    try Uri.Parts("http://contoso?a=" & [url])[Query][a] otherwise [url]

    which gives this result

     

    Check my file above for the full code example.

    Regards

    Phil

        

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi awtahhan 

The column you're trying to decode contains Lists.  Can you please supply some sample data to help me see what youu are working with.  I need to know what is in those Lists.

Regards

Phil

awtahhan's avatar
awtahhan
Regular Visitor
5 years ago

Hi PhilipTreacy 

 

Thanks for your reply, please find below screenshot. The column does not hold full URL, it is only holding the encoded query parameter values. I want to decode those query parameter values.