I built a workflow that uses your idea and does three imports of an Excel file, one all numeric, one all strings and one guess. For the numeric ones when it might actually be a String there will be a huge number of missings. I do a calculation of % missing and I set a variable (75%) if there are 75% or more missing and the guess suggests a String it is a string.
Obviously if you have date variables you would have to do something different.
Here the results are stored in KNIME tables that are named after the Excel file and sheet and also contain columns with that information.
External resources
Used extensions & nodes
Created with KNIME Analytics Platform version 4.1.0
Note: Not all extensions may be displayed.
-
KNIME Core
KNIME AG, Zurich, Switzerland
Version 4.1.0
-
KNIME Excel Support
KNIME AG, Zurich, Switzerland
Version 4.1.0
-
KNIME Interactive R Statistics Integration
KNIME AG, Zurich, Switzerland
Version 4.1.0
-
KNIME Math Expression (JEP)
KNIME AG, Zurich, Switzerland
Version 4.1.0
-
KNIME Quick Forms
KNIME AG, Zurich, Switzerland
Version 4.1.0
Legal
By downloading the workflow, you agree to our terms and conditions.
License (CC-BY-4.0)Discussion
Discussions are currently not available, please try again later.