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...
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 can I parse a string in an object to Date?eg. Date.parse($vendorBill.tranDate, "dd-MM-YYYY") gives me NaNHow would I parse this correctly to return the date in the $vendorBill.string object please?
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...
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...
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...
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...
Ho wcan I pass CDATA to SOAP execute
