This content has been marked as final. Show 7 replies
Hello, I have a few queries about analytic functions, because I am using them for first time.
1. What data type should I define to the arguments? The data type is for the column as a name or for the ιτσ ψ its contents?
2. I need to get only the new column, so what do I have to write in the RETURN line in my function?
My code is this: SELECT COLUMN, COUNT(*) OVER (PARTITION BY COLUMN) ALIAS
RETURN NULL ;
3. As far as Expression Editor is concerned, I am not sure what I should write in the Expression Builder. The new field created will be stored in the target table.
Your help would be essential. Thank you.
The attribute's expression uses the analytic function, for example COUNT(*) OVER (PARTITION BY COLUMN)
The attribute's datatype is dependent on the function and input datatype, mostly numeric/numbers. You should just define expressions referencing the functions in OWB, you shouldn't need to wrapper in any function - for this case.