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

Forum Posts

Value increment for each execution

Hi In Database i have field called “Product_ID” i need to update the field with ‘P-00001’ when i execute the first time and Second time when i execute the field should be updated with ‘P-00002’ please give me an solution how to implement using which ...

pjanapati by New Contributor II
  • 1894 Views
  • 3 replies
  • 0 kudos

Resolved! Pad field with zero

How can i take a sql result field where I am counting the number of people in the file for a trailer and left pad with zeroes? I have tried a bunch of the expressions shown in several of the answers here but nothing is working. I get

PostgreSQL - Bulk Load with schema provided

Hello - I am trying to provide a schema for the PostgreSQL - Bulk Load snap to use. I’m getting an error that “Expecting a schema document with a map of column names to their descriptions”. I have a query that returns the column names and their data ...

chmurray88 by New Contributor II
  • 2345 Views
  • 4 replies
  • 2 kudos

Resolved! Money formatting

I am multiplying a salary field by 100. Any salary with a decimal point is still showing the decimal afterwards even tho in the mapper snap, it looks correct. Here is my code in mapper snap: ($RATE_1*100). It is showing correctly in mapper snap but w...