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

Best answer by Jyoti_Yadav

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

Jyoti_YadavAccepted solution

Level 8

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

Level 2

Could you please share a snapshot?

'A_' +RowId()

Regards,

Vishwadeep

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

Sign up