Skip to main content
Level 3
Jun 18, 2025 11:19 AM UTC
Solved

Row id function

Hi , 

In enrichment activity i creating expression as ‘A_’+Rowid() , now when i am running workflow it is giving below error 

OBD-24000 ODBC error : SQL compilation error: Window function type[ROW_NUMBER] requires ORDER BY in window specification. 

 

How to resolve this issue

Jyoti_Yadav
Jyoti_YadavAccepted solution
Level 8
Jun 18, 2025 3:30 PM UTC

Hi @at7140 ,

 

Try using the expression:

'A_' + CAST(ROW_NUMBER() OVER (ORDER BY creationDate) AS VARCHAR(255))

 

Replace 'creationDate' with the name of a column in your data that guarantees a unique row identifier or provides a meaningful order.

 

Thanks,

Jyoti

3 replies

Jyoti_Yadav
Jyoti_YadavAccepted solution
Level 8
Jun 18, 2025 3:30 PM UTC

Hi @at7140 ,

 

Try using the expression:

'A_' + CAST(ROW_NUMBER() OVER (ORDER BY creationDate) AS VARCHAR(255))

 

Replace 'creationDate' with the name of a column in your data that guarantees a unique row identifier or provides a meaningful order.

 

Thanks,

Jyoti

Translate
Level 2
Jun 23, 2025 8:35 AM UTC

Hi @at7140 ,

 

Could you please share a snapshot?

'A_' +RowId()

 

 

 

 

Regards,

Vishwadeep

Translate
New Member
Jul 8, 2025 11:33 AM UTC

Try using RowNum( OrderBy(1)). It should work.

Translate