Hi Everyone..I have a requirement where we have to split the json which is coming into the json but it is in String. We have to divide into the columns.Let me explain you by the example. The Json is coming in this format.[{"String":"{col_name=CTRY_CO...
Hello, I am trying to connect to the AWS S3 bucket with the Access Key Id and Secret access key using the AWS S3 Account type in Snaplogic. But it fails to validate and throws an error Failed to validate account:Cause: Access Denied (Service: Amazon ...
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...
