Incorrect date format
Hi,
My requirement is to pass the date as a string “YYYY/MM/DD HH:MI:SS” as a parameter to Oracle procedure snap. I amssusing the expression - Date.now().toLocaleDateString({“format”:“yyyy/MM/dd HH...
Forum Discussion
Soumic_Mohanty - one simple solution is to use the error view on the Data Validator, then a Gate to collect the count of errors, followed by a Router to check if there were errors. Finally, re-read the file to begin processing only if there were no issues.
Note that you will want to set your Gate snap "Output Document Count" to either "Document count and first..." or "Document count and last..." option; otherwise, it will consume all input data into memory which could be very resource intensive and not recommended.
The Router then just needs to check the output from your Gate snap to determine if the error path fed into it had any records.
Hope this helps!
Actually, it’s passed from parameter only, please see below and I couldn’t understand what do you mean by _p_processing_date and where I have to pass it?
what do you mean by _p_processing_date
In SnapLogic terminology:
- when you reference a field, it is prefaced with the dollar sign ($)
- when you reference a parameter (which is defined in the pipeline properties), it is prefaced with the underscore (_). Parameters are strings.
So if the p_processing_date was a parameter, you would use _p_processing_date.
In this case, you are mapping a date to a field.
