Make an Automation which handle duplicate records by changing Time

Eswaran

A file containing 5 columns.  make a unique key by combining all columns. If you see the image, the marked items are duplicate records. handle the duplicate records by increasing time to 1 minute except for the first record. example to increase the time from 01:40:42 AM to 01:41:42 AM,01:42:42 AM. so that all records are unique. then do some internal processes and finally change the changed time into the original time like from 01:41:42 AM,01:42:42 AM to 01:40:42 AM in Alteryx. Please do an automation in Alteryx and post.

Book1.xlsx

GMG0241

Hi Eswaran,

If I understand correctly, you want to preserve the information of the data, whilst creating a unique key by combining all the columns. If there is a duplicate, the unique key should differ by increasing the time minute by 1, but keeping the same value in the time column. Please see the attached .yxzp which should do what you're asking.

solution.yxzp