SnapLogic - Integration Nation

Hi,I have 2 input streams, i used inner join and fetched the matching data, also to capture the unmatched data i used- Unmatched data to error view option.I am able to find the get the unmatched/additional records from the left path. How can i get th...

Hi,I have 3 input streams, like below sampleInput-1ASERUFVH816783KGGVKLHOKJGFYGCVJVJHJ7859444MBJHJHGFKJBJGFR565675GGJFJFJGFKFFTDDK67 Input-2KJGLFUDGCLHGIFGFKTDEDDXJGCCHG46533856VHJFHTDGFXCGHCHKGDDDDHGCJVJGT6764468MVNVCHGFH5444755687VHJJFFHGCVJGVJGF55...

Hi,I have 2 dates, which are of localdatetime.Date1 - 2023-08-13T14:17:00.000Date2 - 2023-08-23T05:00:00.000I am using the below expression find the difference between them, and i am getting value as 9.6131944444 expecting the value to be 10. Timesta...

I have 2 date values, have to find the difference between both of them. Weekends to be excluded.I am using the below expression to derive the value.parseInt((Date.parse($Date2.toString())-Date.parse($Date1.toString()))/(1000*60*60*24)*0.71)This logic...

Hi, I am using Oracle-Select Snap to fetch data from DB. Getting error when i pass date value. UPD_DATE is date value in Oracle. Error: “reason”: “SQL [select * from "STVAPP"."TBL_UNITS" where (ID =74341 and TYPE != ‘URM’ and UPD_DATE>‘2019-01-29’) o...