Hi,
I would appreciate help to solve the following problem:
In Excel sheet I have a column set as ‘number’. When Knime reads this column through ‘XLS Reader’ note, it is being recognized as 'DataCell'.
Actually, the ‘number’ column content in Excel is empty (there is just the header cell in the frist row), and maybe because of that Knime is misunderstanding the data.
a) By using ‘column rename’ node I tried to change the DataCell column to IntCell, but in the combo box the only available option is ‘stringvalue’. Why ‘intvalue’ isn’t available? How could I change DataCell column to IntCell inside Knime?
b) I am also using another table from Excel (same structure than the mentioned before), in which there is number content in the column and Knime recognizes it as IntCell properly.
Anyway, a bigger problem appears when I concatenate in Knime both tables (the one with column as ‘DataCell’ and the other ‘IntCell’). The output column is now ‘Non-Native [interface org.knime.core.data.DataValue]’. Then my workflow stuck! How to solve this problem? Actually, it seems that by solving (a) this latter problem wouldn’t even appear!
Many thanks in advance,
Cadu