Tableau To Quick Sight Migration Function Support - Space, char etc

Hi @anshul1243,
As you’ve noticed, Quick Sight and Tableau have different function lists so there may not be a 1:1 replacement in Quick Sight to match your Tableau function. As I do not work with Tableau functions very often, could you please share some explanation of what you’re trying to complete with each function if the suggestions do not seem plausible?

  • Space: You can add spaces to a field by utilizing the concat function
  • Regex_Extract: You could try and explore using a combination of split and substring functions.
  • Regex_Match: You could test out an ifelse function that utilizes the contains function
  • char: This looks like it gets used to convert integers to an ‘ASCII’ code; if that’s correct, there’s no fill in that can accomplish this but you could build out a calc. field that utilizes the switch function. It’s a bit of legwork depending on how many values you have but this could be an option for replacing values with others.
  • attr: You could potentially try something like the following:
    ifelse(min([Field]) = max([Field]), min([Field]), '∗')

Let me know if you have any additional questions or let me know if the suggestions above could be utilized for work arounds in your scenarios.