Knime workflow issue I am running into an issue that I am hoping someone might point me toward a solution, as I have failed to find anything about it online. I am doing some extra experiments with Knime, as I think it is the most likely tool I would be able to have long-term access to since it is free, as long as I don’t need to push anything to production on their server. I have an Excel s/s that I used the Excel Reader node as well as the MS SQL Server connector mode and those both feed into the DG Loader Node. No connection issues but there are several columns in Excel that have a data conversion fail as the SQL server table data type is REAL. Unfortunately I do not have the option of just changing data type in the SQL. Thank you for any guidance anyone might have. I have attached a screenshot of my workflow that has the error messages at the bottom.
Can some help me with the above issue? asap