โ03-07-2023 03:17 AM
Hi
In Database i have field called โProduct_IDโ i need to update the field with โP-00001โ when i execute the first time and Second time when i execute the field should be updated with โP-00002โ please give me an solution how to implement using which snap.
Thanks in Advance !!
โ03-07-2023 08:21 PM
@darshthakkar @alchemiz Can anyone please help on this
โ03-07-2023 08:54 PM
@rjapala You can use a combination of Sequence snap and Mapper snap, as shown below
The expression used for the transformation is โP-%05dโ.sprintf($value)
โ03-07-2023 09:17 PM
Like every time trigger the task then should generate the sequence and update the Product_ID
โ03-07-2023 09:08 PM
Thank you so much @Dheeraj
I have a doubt here like how do we get each time a new sequence should i check with execute or validate