Pipeline expression building

Question

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 · Answer

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

rjapala · Answer

@darshthakkar @alchemiz Can anyone please help on this

dheeraj · Answer

@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 · Answer

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

rjapala · Answer

@Dheeraj
I have a 10 rows in Database with field name ‘Product_ID’ so in pipeline after getting the field i have to take last number like in ‘P-00010’ i have to take ‘0’ and increment by 1 in pipeline and update back to the database like ‘P-00011’ .
Hope you got my point, Please give me solution

Forum Discussion

Pipeline expression building

Recent Discussions

Pagination and nextCursor in header

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?