Designing and Running Pipelines
Discuss how to use the SnapLogic platform.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Resolved! How to Create a SQL Server Connected Lookup

I need to mimic Informatica’s simple connected lookup process. I want to look for a record on a target table and if it exists, update it, otherwise insert it. I have tried to use the Lookup Snap, but I haven’t been able to make it work for me. Does...

Damone by New Contributor
  • 3742 Views
  • 5 replies
  • 2 kudos

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:mm:ss”}).toString() I can see the correct format in ...

amit_saroha by New Contributor III
  • 3868 Views
  • 11 replies
  • 2 kudos

Child pipeline not getting executed

Hi, I am trying to use a pipeline which has two Execute Pipeline snaps, Execute Process 1 and Execute Process 2. (Picture Below) But when running this pipeline, only the first child pipeline is running and not the second one. Even though there is no...

Shaily by New Contributor
  • 2467 Views
  • 2 replies
  • 1 kudos

Date format problem

Hi, I have a CSV file containing the dates like ‘16-DEC-2019’ and I am reading the CSV file and inserting it into an Oracle database table but it always errors out because the format desired is a date in format yyyy/mm/dd hh:mi:ss. I have used the be...

Resolved! Map expression regex

Hi, A simple one for the people that are expert in regex. I’m still learning it. So, I have a key: notes that contains a value : “#IF:SLG-01-SL + some text here” My goal is to always get the 9 characters after an ‘#IF:’ My expression I tried in the ...

Null Values Not Written to Table

My Oracle input is address information similar to: STREET: 123 MAIN STREET CITY: ANYTOWN STATE: ANYSTATE ZIP: 12345 COUNTRY: USA STREET: null CITY: OTHERTOWN STATE: OTHERSTATE ZIP: 54321 COUNTRY: CAN STREET: null CITY: OTHERTOWN STATE: null ZIP: null...

Damone by New Contributor
  • 1821 Views
  • 4 replies
  • 0 kudos