07-13-2019 12:38 AM
Hello Everyone,
I am trying to create an incremental addition let say i have 2 columns empl_id and salary so in target i want to derive third column with cumulative salary.
I can do it by using variable, have done it using Different tool but never implemented it in snaplogic
Hence the question can we create Variable in mapper?
any help is appreciated
07-24-2019 08:48 AM
Hi @Karan_Mhatre, @bhupender.singh
Please find the solution for the above usecase without using the script snap.
The attached pipeline solves your purpose.
variableInMapper_2019_07_24.slp (9.1 KB)
07-26-2019 12:47 AM
Hello Anil,
Really appreciate your effort to find a solution, But i think there is wrong calculation done for cumulative salary.
Can you please check your logic again , please refer to my expected o/p comment?
Thank you again for showing us a way!
07-29-2019 09:36 AM
Hi @Karan_Mhatre,
Yeah the logic was not right,
Please find the latest attached pipeline which solves your requirement.
variableInMapper_2019_07_29.slp (9.6 KB)
07-16-2019 08:34 AM
If you’re not finding any of the specialized snaps are fitting your use case, you could try the Script snap to implement the transformation in JavaScrip/Python/Ruby. Hope you can find something that solves your problem.
07-19-2019 12:33 PM
@Karan_Mhatre
@tlikarish
I have wrote down a script to fulfill your request, please refer to attached pipeline and screenshot.
test_2019_07_19.slp (11.0 KB)