1
I’m importing several spreadsheets into a database, but some of them are having input problems. I’ve even tried to transform the format and use CSV File Input, but the problem remains the same.
The data in Excel is like this:
When I try to import, some columns "change places" and the data of one goes to another:
In this case, for example, the data in the column camada_nome
ended up in the spine profund_inf
Does anyone know why this occurs? There is a solution?
The problem is that I was deleting some columns inside the Microsoft Excel Input step and this causes Kettle to move the columns, generating the error of the exchanged columns. Now it’s working fine, thank you very much!
– Sabrina T.
Correct, Microsoft Excel input columns have to be the same as the file layout, if you need to remove columns, or reorder them, use the Select Values step right after. Also remembering that adding extra columns to the right of the layout does not influence, the problem is adding columns to the left of the layout, which causes a new organization of the data, and consequently the error that was finding happens.
– Cristian Curti