transform a array
Hi there, need some help transforming the arrayI have a structure that's coming as below[ { "statusLine": { "protoVersion": "HTTP/1.1", "statusCode": 200, "reasonPhrase": "OK" }, "entity": { "links": [ { ...
Forum Posts
Resolved! Add column to document and repeat value in each row
I have one document structured like this: FirstNameLastNameTitleAnnSmithMsJuneJonesMrsSamJohnsonMrsAnd a second document like this: LabelValueMyEvent8/21/23I'm trying to merge them together to get a final product like this: FirstNameLastNameTitleValu...
JSON STRING VALUES INTO COLUMNS
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...
AWS S3 Connection failure
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 ...
Resolved! Comparing the schema and discard the Object
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 ...
Resolved! Delaying a process
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...
Return true if values from my input 1 (list 1,list2,list3...so on) are available in input 2 list A
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 ...
Resolved! How to rename a column in a single expression without impacting the other columns in a json file
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...
