I am looking for a way to load data that has many columns that keep changing. For Example the first 2 columns would be the qualifier fields and all columns after that would be an attribute: example from
to having it like this
It is possible to create with an excel file reader and an Alter format step, but the columns will be different in the next file and if no Oranges were taken that column will not be in the file so the job will fail. Also the actual number of ever changing columns can be anything from 20 to 400 - so setting your qualifier fields and automatically adding anything that comes after that as an Attribute field seems like the solution I need.
Anyone have any ideas?
