This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I have a pipeline which is pulling data from 2 salesforce orgs. These data sets are then combined and matched based on the email address using a sort and join (left outer) snap. The end result is an upsert operation is in 1 of the orgs.
When executed...
Hi Everyone,
I need help on an expression solution. The “sum” should be the sum of the value(s) of “key2” from previous records till the current record within the array.
I’m trying to make it using the “reduce” function.
Input:
[
{
"key1": "val...
Hello All,
Is there a way we can use group by fields limited to a group size? Group by fields snap doesn’t let us specify a group size, so if we try to create groups based on a field, whether the occurrence of the field is 5 times or 500 times, outpu...
Hello All,
I have stumbled upon a scenario where we need to map all the elements within an array to the first element of the object or if we have to simplify the use case based on a certain field we have to merge all the elements together. The exampl...
Hi all,
I am getting xml file in array format which i want to conavert to the CSV formate.
lease gud me here for same;
my sml formalt is like :
Name
ROll Number
CLass
0000000000
`
Trying to do ETL to move source data to target db. I don’t want to create a pipeline for every single table. There are hundreds of tables.
To start I want it to do this simply and assume a truncate and reload of all the tables. I will worry about ...
I am reading a list of Dates in excel. Excel region settings are Australian (so dd/mm/yyyy). Excel file sample is:
Using the excel parser the output is all converted to American format (mm/dd/yyyy):
SnapLogic clearly knows it is dealing with Dates....
