CODEWITHSUNDEEP
tableau-api
Lina Linutina
Lina Linutina

Reputation: 443

REGEXP_EXTRACT unknown function on Tableau 10.0.1

I'm using REGEXP_EXTRACT function on Tableau trying to extract numbers from a string. My line of code:

    INT(REGEXP_EXTRACT([Name], '([0-9]+)'))

My colleague can use it and I can't. Getting an unknown function error. We are both using the same version of Tableau, 10.0.1 and mine for some reason is unknown. Do I need to install some drivers or so to get it working? By the way, none of the regex_ functions work on my machine.

Upvotes: 1

Views: 2655

Answers (1)

smb
smb

Reputation: 673

As you are using Amazon Redshift you cannot use the Tableau built in regex-functions. This is because the regex functions are not currently supported in tabelau for redshift. find out more here

In order to get around this you can: 1) Create a tableau data extract from your redshift data source and schedule this to update as required, 2) access them via the raw sql functions (see here)

Upvotes: 2

Related Questions