Pipeline expression building

[rjapala]

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 !!

[rjapala]

@darshthakkar @alchemiz Can anyone please help on this

[Dheeraj]

@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)

[rjapala]

Like every time trigger the task then should generate the sequence and update the Product_ID

[rjapala]

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