Operations

Explode type operation

Adding an explode operation

1 Click on the Explode radio button to access the menu for creating and modifying a process of this type.

2 Drag and Drop the list type columns to "explode" from the Attributes panel to the Columns panel using their move handle.

3 Select the Keep checkbox to keep the corresponding list column in the data table, if necessary.

4 Click on the validate-seize button to save the operation. It is now ready to be executed.

Example of execution of an Explode type operation on the split list type column:

Data processing after an Explode

1 Columns with data before processing 2 Column with data after "Explode" operation

Stack type operation

Stack operation

1 Click on the Stack radio button to access the menu for creation and modification of a process of this type (from the box of dialog for managing Stack and Explode processing).

2 Drag and Drop the column headers of the values to stack from the Attributes panel to the Colonnes panel. Caution, to run correctly, the Stack function requires that the columns thus selected are of the same type.

3 Select this box to keep in the data table the columns whose values will be stacked.

4 Modify the number of lines if needed. By default, it is equal to the number of headers of values to stack. In this configuration, all values are stacked in a single column.

Otherwise, if this number of rows is less than the number of elements in the Columns panel and greater than 1, the stacked values will be spread over several columns. If it is equal to 1, there will be no stacking, the data array of the DataBlock remaining unchanged in terms of its number of rows. If it is greater than the number of items in the Columns panel, the excess cells will be empty.

n5 Click on the validate-seize button to save the process. The Stack processing is ready to run.

The Stack operation displays the stacked values in the last columns of the data array of the current DataBlock, going from left to right. The headers of these columns are identifiable by the presence of the suffix Stack in their label.

The configured operations will only be visible in the data table after loading the step or the entire DataBlock (and therefore all its steps successively).

Result of running Operation Stack as configured above:

Data processing after a Stack

1 Columns with data before processing 2 Column with data after "Stack" operation

Resize type operation

The Resize operation performs an Unpivot operation.

Two situations are possible, with one column (single) or several columns (multiple).

Column types must be consistent

Simple resizing : group with one column

Table before the operation redimensionment simple talbeau avant

Table after the operation simple redimensioning operation result

Handling detail simple resize

1 Choose the operation Resize

2 Drag and Drop the columns that will be preserved to the area 3

4 Specifies the column from which the resizing should apply

5 Specifies the column from which resizing should stop

6 Specifies if the columns should be grouped (1 if none)

7 Label applied to Group column

8 Label applied to Value column

9 Validate: saves and closes the popup

Multiple resizing : group with several columns

Let’s say a value table containing a Date-Time column and 3 batches each containing 3 analyses.

The requirement is to construct a data table containing 5 columns composed as follows

  • A Date-Time column

  • A Group column corresponding to the order of the batches

  • 3 columns Analysis 1, Analysis 2 and Analysis 3

The value table initially with 4 rows-10 columns will then be resized with 12 rows and 5 columns

Translated with www.DeepL.com/Translator (free version)

Table before the operation Table before the operation

Table after the operation Table after the operation

Details of the handling Details of the handling