I'm trying to utilize Oracle functions within a query editor or builder and I can't find out how or if I can do this in TDA. I want to use the First_Value() function.
This Oracle function is not listed in the QB Calculated field’s window.
I was able to successful create a sample query in the Editor and run it successfully.
But I was unable to run it within the QB workflow.