Tableau To QuickSight Migration Function Support - Space, char etc

Q&A
, ,
1

Hi Team,

We are planning to migrate from Tableau to QuickSight and while doing so encountered changes to migrate below functions, can someone help me to sort this out.

Tableau Functions -
Space - add spaces
regex_extract
regex_match
char
attr

Please note, need some kind of compatible function that i apply at dataset calculated field or at analysis level, as we need to replicate as much as possible tableau behaviour and will be doing it though an automated way.

Let me know if any additional information is required.

Thanks,
Anshul..

2

Hi @anshul1243,
As you’ve noticed, QuickSight and Tableau have different function lists so there may not be a 1:1 replacement in QuickSight 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.

3

Hi @anshul1243,

Following up here as it’s been awhile since we last heard from you on this thread; did you have any additional questions or did any of these suggestions help with your case?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you

4

Hi @anshul1243,

Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.

Thank you!