Hi Team,I have one scenario and want to solve it as soon as possible.I have two files : Initial Load , Incremental LoadWe have loaded the initial load data into the DB which contains the columns like : id, name, age, classBut We have the incremental ...
How can i delay a process according to our needs, is there any snap to perform wait operation?I tried with script snap, mentioned there to delay for 15 seconds,but its taking more time than 15 seconds.CODE # Import the interface required by the Scrip...
Hi TeamI have one list of values from input 1 and i need to compare all the values in my input 2 lists and insert into DB or send an error message "One or more values are not part of the input 1 List"Example:Input 1 - [a,b,c,d,e]Input 2 has multiple ...
My source data looks like this. I want to rename "Emp.Type" column to "EmpType" in a single expression without impacting the other columns in json file. I don't want to use column map in mapper where we can rename the column name with individual desi...
I need to produce an HTML email that includes both pipeline variable information in the HTML header and an HTML table that is a multiline error report. I can make one or the other work, but not both. The error report is being read from a database t...
Hi Team, I'm pulling data from the source system which have "n" columns, I wanted to count the number of columns that I'm getting from the Source System. So that to map them with the respective Target System. Please help me out this, Thanks in advanc...
Hi All,I want to convert an input array to expected array. Can you please suggest. Input Array :"Customfield": [{"fieldname": "RECTY","fieldvalue": "S01"},{"fieldname": "LFDNR","fieldvalue": "0000004"},{"fieldname": "ARE4","fieldvalue": "467Q"}]Expec...
Hi team, There are few fields where I'm having value as NULL, I want to make NULL in to blank, in all the Fields where I have the NULL. Help me in a way so that I can write a logic which can replace all the NULL in to Blank.Thanks in Advance.
