Parse values rather than formulae form worksheet
I have worksheet as where values on sheet 2 are calculated with values from sheet 3. when I parse this sheet getting formulae rather than values. Is it possible to get values ?
Forum Posts
Resolved! Dynamic Looping to produce date based on input
Hello, I have a requirement where my pipeline will take 2 input parameters (date type), Start_date and End_date. Based on the input date, i want to generate a list of dates as mentioned below. For Eg : Start_date = 2019-04-01, End_date = 2019-04-05, ...
Find max value
I have output from upstream snap as 20190417 20190416 20190415 20190414 when passing this to a mapper to find max I am getting all the values as Maximum. How to get one Max value and assign it to a parameter ?
MongoDB update snap converts numbers to strings on update and insert
Good Day everyone, I came across this issue when using the mongodb update snap, it seems on update and insert using the upsert setting (on update alone it still gives the issue), all number variables are converted to string in the mongodb database. I...
SQL Server Stored Procedure Snap
Hello, SQL Server Stored Procedure snap has 2 outputs, one for output parameters and another for result set. I am only interested in the resultset, how do I make sure the “output parameter” view is closed? We don’t want to have multiple open outputs...
How to process a CXML file
Hi, Can we process a CXML file in Snaplogic? If yes, Can you please upload a sample pipeline? Thanks in Advance.
Delimeter in Mapper
I have the input value stored in one string separated by delimiter comma. This value is available as Mapper variable. For Example: $inputstring - Value1,Value2,Value3,Value4,Value5 i have to separate these values and store separately in diff variable...
Using Pipeline Parameters in JDBC Snap
The schema name of table is dependent on the environments (Dev, QA, Prod) so we wanna parameterize the Schema name in JBDC Select, Insert, Update and Execute Snap. Can you please guide us on how to achieve that.
