group by function
i am unable to use the group by function using the sql snap. can anyone help
Forum Posts
Snowflake SCD2 - malformed date issue
Hi Team,Can anyone please help me in the following issue which I'm facing with "Snowflake - SCD2" snap.As per my requirement, I have to load the timestamp data into the table (we are receiving the input date data in 12hour format). In the Snowflake t...
Issue with Snowflake - SCD2 snap in SnapLogic
Hi Team,Can anyone please help me in the following issue which I'm facing with "Snowflake - SCD2" snap.As per my requirement, I have to implement SCD Type2, to achieve this I'm using "Snowflake - SCD2" snap in SnapLogic pipeline. In this snap I'm usi...
Resolved! Do JSON mapping in a single mapper
Hi Everyone,This is my sample JSON data.I want to map this data in a single mapper in order to get the result set below.Currently I am using too many snaps to do the same. I want to reduce my number of snaps and get it done in 1 mapper.
Resolved! Problem with nested mappings
Hi guys! I am quite new to SnapLogic and I am having a bit of a struggle with transformations. I worked with Mulesoft previously, and honestly, I am kinda trying to do things the same way but it doesn't really work here. So this is my incoming JSON (...
Saving Excel document from zip file gives unexpected results
Hello all,I'm doing something really simple, but I'm stuck with a basic issue that I don't really understand the root cause.I'm running the pipeline below, which simply downloads a zip file from a server (using HTTP Client), writes the zip on the sld...
Snaplogic Public APIs
Hi SMEs,Good day, any suggestion on how can I setup the basic authorization when invoking Snaplogic Public API using REST POST/GET snaps where ORG/Environment uses a single sign-on ( I tried my network credentials but no luck )Thanks,EmEm
XML FILE Formatting issue
Hi Snaplogic Community,i have designed a pipeline to create a xml file but while create it, i am getting all content in single line. I want to get proper formatting. Please suggest me solution for this issue.Below i am attaching the pipeline screens...
