Karan_Mhatre
New Contributor II
Joined 7 years ago
User Profile
User Widgets
Contributions
Re: Can We create a Variable in Mapper
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!2.9KViews0likes1CommentRe: Replacing Multiple Special Character
@Andrej_Bogdanovski Thank you very much. However i have done these in another way ,may be it will help you ,so know we know 2 ways to do these $Name.replace(/[^a-zA-z]/g,“”). $Name.replaceAll(‘!’,‘’).replaceAll(‘@’,‘’).replaceAll(‘#’,‘’).replaceAll(‘$’,‘’).replaceAll(‘%’,‘’).replaceAll(‘^’,‘’).replaceAll(‘&’,‘’).replaceAll(‘*’,‘’) Hope these help us. Again thank you for your solution.5.4KViews1like1CommentReplacing Multiple Special Character
Hello Experts, I have a source column (Emp_name) where many special character are there in name ,want to remove all the special characters. Tried using replace and replaceAll but i didn’t find a function that can take list of special character like below {!,@,#,$,%,^,&,*}. Source data looks like these:- Emp_id Name 100 Tom!@#$ 200 Scott**& 300 Tig*!!@er 400 N!e@@el 500 #$Je%rry 600 James*&^% I used to do these using convert function in IBM Datastage where is used to pass the list of special character and then replace it,but i didnt find any function here. Can anyone guide me through how can i do it? Appreciate your help.12KViews0likes3CommentsRe: Can We create a Variable in Mapper
Hi tlikarish, Appreciate your reply but that does not solves my query. Below is the data:- employee_id,salary 10, 1000 20, 2000 30, 3000 40, 5000 Expected O/p employee_id,salary,Cumulative salary 10, 1000,1000 20, 2000,3000 30, 3000,6000 40, 5000,11000 Hope now its clear , Also i tried to Google for variable in mapper but there was no comments or article on it. Can we not create a variable in mapper? because these can be done in different ETL tools using variable.3.8KViews0likes1CommentCan We create a Variable in Mapper
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