Hello, can someone please help with this? I was to extract each of the { "securityAlt":[...], "security":[...]} section out of the main array, and store each record on oracle table under a field. So for this below example, I want to insert the 12 obj...
Hi, I am seeing what seems to be maybe a limitation of the SCD2 snap. I am using the SCD2 snap to load some Snowflake columns named as such: <parent>.<key>. So for example this could be something like PERSON.PHONE which pertains to the following in a...
Hi, I am seeing what seems to be maybe a limitation of the SCD2 snap. I am using the SCD2 snap to load some Snowflake columns named as such: <parent>.<key>. So for example this could be something like PERSON.PHONE which pertains to the following in a...
i have cobol file with this format can someone help me how to read this file. it's fixed width format and character set EDCDIC to UTF-8 any existing logic or script which will help
SnapLogic has a Box Snap Pack which works very well for the majority of day to day Box operations. The snaps are easy to use and connecting to Box using the Box Account is very simple. I would recommend using this Snap Pack if the snaps meet your n...
Hi all,I have a requirement with me that I need to create a triggered task automatically with the pipeline parameters of the existing scheduled tasks using the snaplogic create snap.Is it possible to do that? If yes, please let me know how can i figu...
Hello,I have a stored procedure that returns the following and i need that dataset transformed into the expected result. Thanks you for taking a look.Stored procedure result/input: [ { "RiskLevelCode": "High", "RiskLevelName": "High Risk", ...
I have data from salesforce that contain fields with a suffix of '__c' and the dates are formatted in UTC. I want to format the incoming data using the mapValue and the mapKey functions to remove the suffix and make all fields lower case AND format t...
