Hi,

Thanks for the question.

The Fix fields operation has been added recently. It allows you to specify the "Output" fields and map them to "Input" fields. It is used to ensure that if the data changes upstream (fields are added/removed or renamed), the structure of the fields downstream is not affected.

To see how the fix fields operation works try the following:

1. Open DataManager and add a "Demo data" source. Select the "Human Resources" data.
2. Connect the "Demo data" block to a "Field organiser" block.
3. Now connect the "Fix fields" block to the "Field organiser" block.
4. Initially the list of fields is blank. Click the "Reset mappings" button and choose "Yes, reset". An initial list of mappings will be generated. The fix field operation will now guarantee that the output mappings will not change. We can demonstrate this by simulating a change upstream.

To simulate a change:

5. In the field organiser block click "Add field". After adding the new field the Fix fields operation shows an error message, however the list of mappings are maintained. We can choose to show a warning instead of an error by selecting "Tools>Unused input fields>Show warning".
6. Now in the field organiser block rename the first field "Employee name" to "New employee name". You should see a warning message appear in the Fix fields operation, however the "Employee name" output field is still maintained but now is mapped to no input field. Simply click the input drop-down and change the mapping to the "New employee name" field. Alternatively choose "Tools>Mismatching output fields>Show warning" to allow the data to pass through (Employee name data will be empty).

I've attached an IOK file with the configuration described above, please let me know if you have any further questions.

Regards

Chris

Hi Chris,

Thanks for the information.

Omar