cancel
Showing results for 
Search instead for 
Did you mean: 

Error While activating the Scripted calculation view

Former Member
0 Kudos

Hi Guys,

I am getting the following error while activating the scripted calculation view. Please find the below screens for details.

The same script is executing in SQL console but in cal view getting error.

Please help me.

TIA

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Your output columns should basically match whats in the script in that order.

I noticed that rank and dense_rank aren't part of the output list. Kindly include/define them in the output and redeploy the calc view.

Regards,

Nihal

Former Member
0 Kudos

Hi Nihal,

Thank you,Issue has been solved

I have done a mistake by mention rank as lowercase

Answers (1)

Answers (1)

former_member183326
Active Contributor
0 Kudos

What version of Studio are you using?

Former Member
0 Kudos

Hi Michael,

Please find the below screen for version details

Thank you