I define an Excel Input block to import a 3-rows Excel file. I found that, if I switch the header and content of two columns, the field load is positional, i.e. Kettle don't notice the change and ignores the columns name.
Is there a way to check the columns name (to abort the load procedure) or to load data based on column names (not column position)?
Thank you for any hints