Row id function

[at7140]

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 · Accepted solution]

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

[Vishwadeep]

Hi @at7140 ,

Could you please share a snapshot?

'A_' +RowId()

Regards,

Vishwadeep

[Saikat903852]

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