Hi David. Whereever you have "then ocfv.str_value" can you try adding a substring or a left and see if this helps? Such as "then left(ocfv.str_value,20)" Try it out...
Thanks for the suggestion, the query is working. Do you know if there is a way to configure Tableau to handle dragging a table that contains that column to load data? I know now I can use custom SQL query, but would be nice to use Tableau to just drag tables without having that error occur.