Forum Posts
Resolved! Parsing CSV file
Hello, Below is the requirement where I have to read and parse a CSV file and load each line based on the first column's name. The file will have thousands and thousands of lines.I have the sample csv file below and 1st line will be Header and will ...
How to split data in a nested array into multiple rows?
I'm trying to simply split an array of fields within an array into two discreet records for example in the above illustration, how do I split the array lineList into two records one for credit and one for debit based on the two elements in the arr...
Resolved! Data Validator Pattern error
Hello, I am building an API that used PUT method to update a set of JSON data into my taget database. One of the contents of the PUT method is a boolean type that would receive ether a "true" or "false" and is a mandatory entity.I am using a Data Va...
Resolved! Deleting multiple files at once from SFTP folder
Hello, I have a process where the files needed to be deleted from the SFTP folder after the files are copied and processed. At a given point of time there could be hundreds of files and after copying and processing these files, I have a separate pro...
Resolved! SQS -pipeline stalling
Hi All,I am facing a peculiar issue with a new pipeline being built. the pipeline is setup to consume an SQS message > apply some processing and auditing(Via MySQL DB) > acknowledge the SQS messageThe pipeline runs correctly when the SQS Consumer Sna...
Resolved! Changing poorly formatted date into a clean date
I’m working on creating a few pipelines to transform some data, but I’m having an issue with the date field. The date field I pull is a string and not a date which is the main issue. It’s formatted as MMM 'yy so as an example October 2022 would be fo...
Passing Cdata to xml
Ho wcan I pass CDATA to SOAP execute