I have a folder full of SQL word pads that I must transfer over into Tableau by way of "Create New Custom SQL". Is there a sound way to do this? I haven't been able to find any resources, so any and all suggestions could benefit me at this point!
I appreciate you!
21 answers
Yep.
You're trying to call functions with variables in your SQL.
pr.policy_revision_seq = f_in_force_revision(pr.policy_seq,NULL,f_end_of_day(:as_of_date))) l,
You can't do this with Tableau.
You would need to modify your query so that it performs the logic that the function would be doing from within the statement.
If you're not a DBA I would reach out to whoever created this SQL and explain to them your situation.
They might be able to convert this for you.
