Hello everyone,
I made a loop to read all the excel files in the same folder. Every week I add one new excel file to the folder. Those excel files input are always the same format. Therefore the data base became bigger and bigger.
Unfortunately, this week I input the weekly file (which is exactly the same as the previous ones) but it did not work. Somehow, the knime started to read wrongly some columns (integers instead of strings, numbers -D- instead of date). My knime does not work anymore as the previous files and the new one are not seen as having the same format on knime.
I do not want to add any node, I would just want the knime to work as before. The problem comes straight from the input so I would like to tackle it at that moment. What could be the reason of my situation ?
Thanks a lot for your help !