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.
I have an incoming file that has a date value of 00:00.00.000 as a value. I am trying to set it to null. Comparing the exit_date ==‘00:00:00.000’ fails. Checking Date.parse($exit_date)==’ ’ or Date.parse($exit_date==null fails. Date.parse($exit_d...
When I’m trying to insert data into the Teradata table, I also want to insert the pipeline run time id into a column to log as an entry. Can anyone suggest a way to get the id into a mapper when the pipeline is executing?
Hi there,
I’ve looked at other articles addressing this but non has helped me so far.
Im looking to format a date in the DD/MM/YYYY to YYYY-MM-DD.
The date will always be populated.
I’ve tried the following expressions but they wont process correctly...
Hi,
I have run into an interesting situation where my XML generator is not populating entire CSV file I reading. Basically, I am reading CSV file and trying to send that as one batch to SAGE Intacct using XML generator. but, in turn the XML generator...
I am building a pipeline which need to make recurring API call and consolidate the result. But when I call the API inside py script snap then it does not return result as the API default result. I tried to use two methods of get as get.getResponseBo...
Hello,
If I have 3 records that I want to insert into my database table, I use the “SQL Server - Insert” snap. However, if there’s 1 record that has an error (like let’s say one of the values has text in an int column), the 2 other records still cont...
Wondering if someone could answer this question for me. Given the below array, how would I get the index number of $arrayField.name ===“Alex”?
I can easily get the index of true and false by respectively doing this: $arrayField.indexOf(true) and $ar...
