Reltio Integration Hub

Hi All,
Is there any way to generate serial number/sequence number in a sql query in Collection action in RIH?

I have used 'row_number() over(order by col1)' function and 'rank() over(order by col1)' function but its giving a syntax error, is there any other way to use them in Collections in RIH or any other way to generate serial numbers?

Hi ,

you can use below formula, it will make number from date 

=now.strftime("%s%L")

regards,
Nitin Tugave

------------------------------
Nitin Tugave
eaton
------------------------------

Hi Nitin,
with the above formula, its not generating random number but the dates in Epoch time.
Can you please check or suggest any other way?