Behavior of Pivot Snap when the Treat selected fields as static checkbox is Deselected

This example pipeline demonstrates the expected behavior of Pivot Snap when the Treat selected fields as static checkbox is deselected (default option).


CSV Generator configuration for Pivot Snap example

  1. Configure the CSV Generator Snap

    First, configure the CSV Generator Snap with the data as shown in the image.


    CSV Generator Snap and output

  2. Configure and validate the Pivot Snap

    Next, configure the Pivot Snap to substitute null values for the selected fields ($['2010'], $['2012'], $['2014'], $['2016'], $['2019'], $['2020']) and deselect the Treat selected fields as static checkbox.


    Pivot Snap Configuration

  3. Validate the output

    On validating the Snap, the Snap returns all the fields in the output as per the configured behavior for the selected fields.


    Pivot Snap output

  1. Ensure that the Treat selected fields as static checkbox is deselected in the Pivot Snap.
  2. Validate the CSV Generator configuration and data preview.
  3. Observe how all selected fields are returned in the Pivot Snap output.