ContributionsMost RecentMost LikesSolutionsRe: Problem with copy and join Did you mean Join Snap when you referred to Lookup snap here ? Also what is the output from the Aggregate Snap and Mapper after that ? Re: Downloading files stored in Google Drive When you click Authorize you are redirected to a different browser and on that you should’ve been prompted the drive access. Also Make sure you have drive API Access enabled too on the App. Re: Downloading files stored in Google Drive 403 is Authorization issue. Can you check if you have the right permissions. Did you enable the Checkbox while you were Authenticating the account. I didn’t have any issue viewing the files on the drive with Rest Get Snap. Re: Array vs Non Array An Alternative way of doing it would be on Mapper you can split $LINES[*].E1EDPT1 and in the mapper sl.ensureArray($E1EDPT2) for_Array_Text_2021_07_30 (1).slp (6.0 KB) Re: Pipeline Parameter in create statement Have the expression button enabled and its missing the Plus (+) Re: Dynamic file name in excel format Am assuming that field names are missing ? You can work your way around it so that all the fields come in the first record. You can do a Groupby and then sort it through an expression. Below is the known limitation on the snap. The Snap prepares the column header for the output view (and hence the CSV file) using the keys defined in the first record. This may result in ignoring any additional key passed in the subsequent records. We recommend that you pass values for a comprehensive set of all keys used in the input view, for the first record. Re: Copy snap creating output that is multiplied by number of records Copy Snap shouldn’t be the issue. It just duplicates the data to send to multiple endpoints. I see that Oracle Execute has input view. Can you send the slp file. Also Dashboard is good place to monitor the records. Re: Migrating Oracle Number to SQL Server Numeric Hello, did you try object.toFixed() ? Re: Sum of values in array of objects without reduce function You can use merge function too. https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1439367/Object+Functions+and+Properties#ObjectFunctionsandProperties-merge Community_Example_2021_05_11.slp (3.5 KB) $group.map(x=>x.merge({“sum”:$group.map(item => item.key2).reduce((accum, currentValue) => accum + currentValue)})) Re: How to Transform SQL Server Records to JSON usable format That’s just a sample. We can do achieve the desired o/p with looping in Velocity Template.