This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
How can I trim the date on the left hand side and convert this into a date value? Input Example: 18 May 2016 - 17 Mar 2017 Output example: 2016-05-18 (using the yyyy-MM-dd format) I've trie...
Hello, I have designed this pipeline that: Generate a month range as $date_1 and $date_2 These variables are inserted into a SQL statement in the "Snowflake - Execute" pipe Then this is inserted...
Hello, I am using the Multi file Reader Snap to copy the files from a SFTP source location and write into a Storage blob container. The process is to run every 30 mins to pick any file(s) th...
Hello, I have source data in XML format and all the column entities have "@" as a prefix. I am trying the following expression using "hasPath" function in a mapper to determine if the output o...
I am building a generic error pipeline which will load error occuring in the source pipeline and write them/load them into a database. It will load data such as label, user, etc. on which the error t...
First time trying to format into XML with SnapLogic. I have CSV data that I am trying to convert into XML. There are repeating elements, possibly multiple, in the schema. I've pared down the s...
Hi, I first do an SQL Server - Execute and get this weird {_snaptype_localdatetime: "..."} for the CreationDate and LastUpdate fields. Then, using a Mapper snap I do toString() to just get the ...
I have this below code, but the output csv contains \n instead of giving line break $id + '\n' + $crse_detail.toString().replace(/;/g, '\t\t').replace(/,/g, '\n') + '\n' + '**********' + '\n...
Hello, I'm looking for help with an expression to extract values in nested JSON objects. I've figured out how to extract any elements in "field" array where "lastModified" is after "lastExtractionD...