Resolved! String replace method where pattern is dynamic
Hi SMEs,Quick question, is there a way to set the regex pattern in replace method dynamically?Example: Thanks
Forum Posts
Select N largest from each group
Hi, I am building a pipeline to select latest datetime from the data file. I also need the latest value for all source_code (essentially a groupby and then max value of within group). I tried Aggregate function to select MAX over datetime and in the ...
Parsing date for filtering
Hello, I am having trouble filtering dates in the Filter snap. I want to:Filter for a specific month and year, example June 2024If it's possible to add "OR" condition, then from 2 columns, otherwise one column is fineValues from the date column are i...
Implementing Pagination in SnapLogic for Google Search Console API
Hi Everyone,I hope you're doing well. I need some assistance with implementing pagination in SnapLogic for the Google Search Console API. Currently, there's a row limit of 25,000, making it challenging to load the data on a daily basis. If the data e...
Resolved! Send Multiple HTML Tables in Email using XML Parser
Hi, I am working to send multiple tables in a single email using XML Parser.I am using Groupby Field snap to for group respective categories and send out details of each category as a table(in a single mail)Following is the structure of JSON file.[{ ...
Salesforce Read - Where Clause Syntax
I am reading a csv file from S3, and I need to perform a validation to see if the record exists, and was created within 90 days, from the Opportunity object. If it meets the below criteria, then I need to reject it. I switched from using the Salesfo...
SQL Server - Bulk Load
Currently I'm having issue when doing a bulk insert where values are set to NULL from field names that doesn't match from the source column names even though column position are the same , e.g Target Table Field name is NotifyCode while Source SP is ...
