I am using Tableau 10.5.1 with an Oracle data source
I am trying to use a regexp function to join two tables where one field needs to join on the first few digits.
My issue is that I am getting an error "Unknown Function REGEXP_EXTRACT called" when trying to enter the join calculation. the regexp function works everywhere else except on the join calculation.
Just a note I was able to work around this by creating a field using a regexp statement using a custom query to bring the table in.
Not entirely sure, but perhaps REGEXP can't be used in join calculations.