Excel Serial to Date

This component is to convert excel serial number to Date.
Outout is to add "Date" column in the end.
1. select serial number column
2. execute
3. added "Date" column

Excel bugs are considered in this componet logic.
row order would be changed in case you have the data with serial number less than equal to 60.

Options

Serial-column

Please select serial column with number data type

Nodes

• Column Rename (Regex)2 ×
• Math Formula2 ×
• 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