Icon

JKISeason2-17

I added the error trapping to a workflow I developed in response to this post on the Forum:

https://forum.knime.com/t/day-date-manipulation-based-on-conditions-move-forward-or-backward/70553/4

The error I tested was incorrect data imported from a test Excel file.

To rerun:1. Reset Start Time node.2. In Excel Reader change to row from 9(successful) to 12 (failed) to test Try_Catch. Read 1stData TableExtract Day ofWeekRename Headers& Remove UnnecessaryColumnsRemove HeaderRowCreate Day ofWeek #sCreate DateDifferenceLimit DateDifferenceto +/-3Calculate PackingDateStartTimeEndTimeNode 15Node 16Node 17Node 18Extract WorkflowPropertiesCreate PropertiesTableCreate ErrorTableSelect DesiredPropertiesJoin PropertiesNode 25Select ErrorCategoriesJoin PropertiesNode 28Fill Missing ValuesNode 30Remove UnnecessaryRowAdd Start TimeCreate FinalTableWrite SuccessfulTabWrite FailedTabNode 39 Excel Reader Extract Date&TimeFields Table Manipulator String to Date&Time Row Filter Rule Engine Math Formula Rule Engine Date&Time Shift Create Date&TimeRange Create Date&TimeRange Try (Data Ports) Catch Errors(Data Ports) Empty Table Creator Joiner Extract ContextProperties Variable toTable Row Variable toTable Row Table Manipulator Joiner RowID Table Manipulator Joiner Concatenate Missing Value RowID Row Filter Joiner Table Manipulator Excel Writer Excel Writer Wait... To rerun:1. Reset Start Time node.2. In Excel Reader change to row from 9(successful) to 12 (failed) to test Try_Catch. Read 1stData TableExtract Day ofWeekRename Headers& Remove UnnecessaryColumnsRemove HeaderRowCreate Day ofWeek #sCreate DateDifferenceLimit DateDifferenceto +/-3Calculate PackingDateStartTimeEndTimeNode 15Node 16Node 17Node 18Extract WorkflowPropertiesCreate PropertiesTableCreate ErrorTableSelect DesiredPropertiesJoin PropertiesNode 25Select ErrorCategoriesJoin PropertiesNode 28Fill Missing ValuesNode 30Remove UnnecessaryRowAdd Start TimeCreate FinalTableWrite SuccessfulTabWrite FailedTabNode 39Excel Reader Extract Date&TimeFields Table Manipulator String to Date&Time Row Filter Rule Engine Math Formula Rule Engine Date&Time Shift Create Date&TimeRange Create Date&TimeRange Try (Data Ports) Catch Errors(Data Ports) Empty Table Creator Joiner Extract ContextProperties Variable toTable Row Variable toTable Row Table Manipulator Joiner RowID Table Manipulator Joiner Concatenate Missing Value RowID Row Filter Joiner Table Manipulator Excel Writer Excel Writer Wait...

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: genef
Created at: 2023-07-13
On NodePit since: 2023-07-21
Last update: 2024-04-27
Created with KNIME version: v4.7.5
Tags: JKISeason2-17

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!