Value increment for each execution

[pjanapati]

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

[pjanapati]

Hi @AleksandarAngelevski ,
Can you please help me on this.

Thanks in advance.

[Dheeraj]

@pjanapati Please refer to this post

Pipeline expression building Designing Pipelines

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

[pjanapati]

Thank you @Dheeraj