Question about creating an analysis.
I want to create a table that contains URLs encoded in columns.
Can this be accomplished using QuickSight’s built-in features?
This was not possible by using computed field functions and operators.
| url | encoded_url |
|---|---|
http://example.com |
http%3A%2F%2Fexample.com |
@shinya.sakae - There’s no out of the box encode function to achieve what you are looking for; however I am wondering is it possible for you to use the ifelse() or switch() function to conditionally replace the characters with its corresponding encoded character values? Obviously this is going to work if you have somewhat finite number of characters that you are trying to replace. For your given example, there are only 2 characters that you shown which have been replaced “:” and “/”. Let me know if this helps!
@sagmukhe Thanks for the reply.
I want to do the equivalent of encodeURIComponent.
Changing “:” to “/” is not sufficient.
Tagging few experts for their insights regarding this :
This will need to be a feature request, unless you do an ifelse for every possible substitution.
I can mark it as one.
Hi @Max
Please do mark it.
Thank you.