Fix Numeric Excel Dates

This component fixes an issue where the Excel Reader outputs a double instead of a date column. The double represents the number of days since 1st of January 1900 and a correct date can be obtained by shifting that day by the given number of days using the Date&Time Shift node. In this component the shifting and column replacement logic is encapsulated.

Options

Date Column

The column containing a numeric date representing the number of days since 1st of January 1900.

Nodes

• Column Filter1 ×
• Column Rename1 ×
• Column Selection Configuration1 ×
• Component Input1 ×
• Component Output1 ×
• Show all 10 nodes

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Math Expression (JEP)
• FeatureKNIME Quick Forms

Links

• No links available