Snap Pack History: Transform

  • Release Name
  • Date
  • Snap Pack Version
  • Type
Updates
  • September 2022
  • 430patches17737
  • 08 Sep 2022
  • Stable/Latest
AutoPrep now enables you to handle empty or null values.
  • August 2022
  • 430patches17643
  • 26 Aug 2022
  • Latest
The CSV Parser and CSV Formatter Snaps now support either \ or \\ for a single backslash delimiter which were failing earlier.
  • August 2022
  • 430patches17589
  • 23 Aug 2022
  • Latest
The CSV Formatter Snap does not hang when running in specific situations involving multibyte characters in a long field. If you notice the CSV Formatter Snap is hung, we recommend that you update to the 430patches17589 version and restart your Snaplex.
  • August 2022
  • main17386
  • 11 Aug 2022
  • Stable
  • New Snap Application: The AutoPrep Snap provides a data preparation application where you can flatten structured data, include and exclude data fields, and change data types before forwarding the data for further processing.
  • The Hide whitespace option in the CSV Generator and JSON Generator Snaps allows you to hide the rendering of whitespace as symbols (dot or underscore) in the output if whitespace symbols occur in the CSV or JSON input documents.
  • The Render whitespace checkbox in the Mapper Snap enables or disables the rendering of whitespace in the input document. If Render whitespace is selected, blank spaces (leading, trailing, or spaces in the middle of a string) in the value of the Expression field are rendered as dots (.) or underscores (_) in the output.
  • The Excel Parser Snap includes the Custom Locale dropdown list that allows selecting a user-defined locale for formatting numbers.
  • The Selected fields option in the Pivot Snap allows you to define fields to be unpivoted so that the remaining fields are automatically pivoted.
  • The XML Generator Snap includes examples on how to escape single (') and double quotes (") when used with elements or attributes.
  • 4.29 Patch
  • 429patches16990
  • 22 Jul 2022
  • Latest
  • Fixed an issue with the Aggregate Snap where the Snap failed to validate (after first successful validation) while using a field that may contain a date for MIN and MAX functions. The Snap now supports DATE-type fields.
  • Enhanced the Pivot Snap with the Treat selected fields as static checkbox that enables the Snap to treat the selected fields as static to preserve the structure of the selected fields while all other fields are pivoted.
  • 4.29 Patch
  • 429patches16923
  • 21 Jul 2022
  • Latest
  • Enhanced the CSV Formatter and CSV Parser Snaps to support multiple characters or strings as delimiters.
  • Fixed an issue with the Join Snap where the Snap displayed an incorrect error if the Left path or Right path fields were expression-enabled or if you have specified properties other than the field name and irrespective of whether the Sorted streams field is Unsorted or not. For example, $first + '2'. Now, the Snap runs properly if the Left path or Right path was expression-enabled and you have specified properties other than the field name and the Sorted streams field is Sorted or Unsorted. The Snap now displays a proper error that is more informative, in case there is a problem while executing this Snap.
  • Fixed an issue with CSV Parser Snap where the Snap failed when more than six characters are used as delimiters. Now, the Snap executes properly when you use more than six characters as delimiters.
  • 4.29 Patch
  • 429patches16521
  • 07 Jul 2022
  • Latest
  • Removed the default value for the Root element field in the XML Formatter Snap.
  • Fixed an issue with the Transcoder Snap where the Input character-set field was not displaying the suggestions properly.
  • 4.29 Patch
  • 429patches16026
  • 05 Jul 2022
  • Latest
Enhanced the Excel Parser Snap with the Custom Locale dropdown list that allows you to select a user-defined locale to use when formatting numbers.
  • 4.29
  • main15993
  • 14 May 2022
  • Stable
  • Fixed an issue with CSV Formatter and CSV Generator Snaps that displayed an incorrect error when one or more header values in the CSV file were missing. This error is now routed to the error view.
  • Fixed an issue with the CSV Parser Snap, where the Snap stopped indefinitely while processing certain inputs.
  • Fixed an issue with the CSV Formatter Snap, where the escape character selected was not used.
  • Updated the CSV library used in the CSV Generator, CSV Parser, and CSV Formatter Snaps. This library update enforces values for each column in a parsed CSV header.
  • Enhanced the XML Formatter Snap with the Output Character Set field. You can select the character set you want for your binary output. For example, UTF-8 or ISO860.
  • 4.28 patch
  • 428patches14370
  • 25 Feb 2022
  • Latest
Fixed an issue with the XML Generator Snap, where the Snap failed with an invalid UTF-8 sequence error when running on the Windows Snaplex.
  • 4.28
  • main14627
  • 12 Feb 2022
  • Stable
Updated and certified against the current SnapLogic Platform release.
  • 4.27 Patch
  • 427patches12966
  • 12 Jan 2022
  • Latest
Enhanced the Avro Formatter Snap to display meaningful error message while processing invalid and null values from the input.
  • 4.27
  • main12989
  • 15 Nov 2021
  • Stable and Latest
Fixed an issue in the Group By Fields Snap that caused the Snap to abort with an error when executed with zero input documents.
  • 4.27
  • main12833
  • 13 Nov 2021
  • Stable
  • Added dynamic memory management to the Group By Fields Snap, which can activate with the following settings:
    • Memory Sensitivity: The Snap's response to the memory changes.
    • Min Part Size: The minimum size of the parts that the Snap splits larger groups into.
  • Enhanced the JSON Formatter, JSON Generator, and JSON Parser Snaps with the Support Type Extensions checkbox. If this checkbox is selected, the Snap supports SnapLogic-specific syntax to represent non-standard data types, such as byte arrays and date objects in JSON.
  • Added the following checkboxes in the Excel Multi Sheet Formatter Snap:
    • Convert numeric string to number: Sets the behavior of the Snap when a value in the input document is a numeric string. This checkbox supports the conversion of numeric values to string values.
    • Translate date and time types: Sets the behavior of the Snap when a value in the input document is a date and datetime type. This checkbox supports translating date and time types to Excel date numeric type with date format style.
  • 4.26 Patch
  • 426patches12086
  • 07 Oct 2021
  • Latest
Fixed an issue with the Join Snap, where it exhausted the memory while buffering millions of objects.
  • 4.26 Patch
  • 426patches11780
  • 27 Sep 2021
  • Latest
Fixed an issue in the Join Snap, where the Map input to first repeating element in XSD checkbox is selected, while no XSD is specified for mapping the input.
  • 4.26 Patch
  • 426patches11725
  • 18 Sep 2021
  • Latest
Fixed an issue with the Join Snap where the upstream document flow of the right view is blocked by the left view, which hung the Join Snap.
  • 4.26
  • main11181
  • 14 Aug 2021
  • Stable & Latest
  • Enhanced the JSON Splitter Snap with a new field Show Null Values for Include Paths that enables the Snap to show key-value entries of the null values for the objects added to the Include Paths field in the output document.
  • Enhanced the Join Snap with a new field Available Memory Threshold (%) that enables the Snap to keep all the Right-input view documents with the same join-path values in memory until the join operation is done for the specific join-path values.
  • 4.25 Patch
  • 425patches10663
  • 13 Jul 2021
  • Latest
Fixed an issue in the CSV Formatter Snap, where even if the Ignore empty stream checkbox is not enabled, the Snap did not produce an empty binary stream output in case there is no input document.
  • 4.25 Patch
  • 425patches10152
  • 08 Jul 2021
  • Latest
  • Replaced the Strict XSD output field with the Map input to first repeating element in XSD field in the Join Snap. If selected, the Snap ignores the root element from the XSD file.
  • Enhanced the CSV Parser Snap with a new checkbox Preserve Surrounding Spaces that enables you to preserve the surrounding spaces for the values that are non-quoted.
  • 4.25 Patch
  • 425patches9815
  • 27 May 2021
  • Latest
Fixed a ClassCastException error in the Avro Parser Snap and handling of the map, fixed, enum, and bytes data types in the Avro Formatter and Avro Parser Snaps.
  • 4.25 Patch
  • 425patches9749
  • 27 May 2021
  • Latest
Enhanced XML Parser Snap to recognize input headers when defining inbound schema.
  • 4.25 Patch
  • 425patches9638
  • Latest
Reverts the Join Snap to the 4.24 release behavior. This is in response to an issue encountered in the Join Snap in the 4.25 release version (main9554), which can result in incorrect outputs from all Join Types. 425patches9638 is the default version for both stable and latest Transform Snap Pack versions for orgs that are on the 4.25 release version. No action is required by customers to receive this update and no impact is anticipated.
  • 4.25
  • main9554
  • 08 May 2021
  • Stable
Enhanced the Group By N Snap with the following settings:
  • Memory Sensitivity: The Snap's response to the memory changes.
  • Group Size: The maximum number of input documents to be grouped into a single output document.
  • Min Group Size: The minimum number of input documents to be grouped into a single output document.
  • 4.24 Patch
  • 424patches8938
  • 15 Mar 2021
  • Latest
  • Fixed the timestamp issue in the JSON Formatter Snap that changed the time zone offset to include colon by default after upgrading to 4.24.
  • Fixed the null pointer exception at runtime in the Fixed Width Parser Snap by setting the Trim column data field to false for empty columns.
  • Enhances the Group By N Snap to process the records efficiently by adding the Flush Timeout field that enables the Snap to flush a partial group of records if the time specified in this field passes with no new input.
  • 4.24
  • main8556
  • 13 Feb 2021
  • Stable
Updated and certified against the current SnapLogic Platform release.