Hello!
I’m attempting to create a calculated field in my dataset that uses the replace
function to strip escape characters () from a string field. I’m currently receiving an error message when attempting to create this calculated field. It tells me:
function replace has incorrect argument type replace(<STRUCTURED>, String, String). Function syntax expects String, String, String
I’m not sure if it’s relevant but the field I am passing as the first parameter to replace is a string field that I used JSON_EXTRACT on to pull from my underlying SQL database into SPICE.
Any guidance would be appreciated as to whether I’m incorrectly using part of the QuickSight functionality here or if this is a problem I need to solve further upstream (either in my custom query or in the SQL database I import from).
Thank you!