Freeze columns 2.0

Data node A01_raw-data_1 is created using Create Table and contains four columns. The number of columns and their types have to be verified before further processing. This will be done by freezing the number of columns and the types in data node A02_freeze-columns-number-and-type.

On data node A02_freeze-columns-number-and-type, operator "Freeze columns 2.0" is applied to A01_raw-data_1 with the following settings.

The frozen columns equal the current columns in A01_raw-data_1, so no error is reported in the "Operations" view of A02_freeze-columns-number-and-type.

Then the column "Value" is deleted from A01_raw-data_1 by changing the Create Table operator.

Now data node A02_freeze-columns-number-and-type throws an error.

Error details in the "Operations" view of A02_freeze-columns-number-and-type.

Confluence op freeze columns.gzip

Data node A01_raw-data_2 is created as a copy of A01_raw-data_1. The complete table schema has to be verified before further processing. This will be done by freezing the number of columns, the types, and the headings in data node A03_freeze-all.

On data node A03_freeze-all, operator "Freeze columns 2.0" is applied to A01_raw-data_2 with the following settings.

The frozen columns equal the current columns in A01_raw-data_2, so no error is reported in the "Operations" view of A03_freeze-all.

 Then, in data node A01_raw-data_2, the column "Identifier" type is changed to "Integer" and the heading of column "To" is changed to "Until" by changing the Create Table operator.

Now data node A03_freeze-all throws several errors in its "Operations" view.

 Confluence op freeze columns.gzip

Data node A01_raw-data_3 is created as a copy of A01_raw-data_2. Before further processing, added columns are to be removed.

On data node A04_delete-additional-columns, operator "Freeze columns 2.0" is applied to A01_raw-data_3 with the following settings.

The frozen columns equal the current columns in A01_raw-data_3, so no error is reported in the "Operations" view of A04_delete-additional-columns.

 Then, in data node A01_raw-data_3, the heading of column "Until" type is changed to "Foobar" and the column "Note" is added by changing the Create Table operator.

Now data node A04_delete-additional-columns is a copy of A01_raw-data_3 with columns "Foobar" and "Note" removed.

Note that column "Foobar" is also removed, even though it is an original column where the heading has been changed. 

A04_delete-additional-columns "Operations" view 

A04_delete-additional-columns "Details" view 

 Confluence op freeze columns.gzip