I have a table in a source Excel file (which I can't change) with fields as follows: Company, 1990, 1991, 1992, 1993, etc. where "Company" is the name of the applicable company and the year fields contain sales information. There are about 30 years in total.
For workability, I would like to change the structure of the table during the load to have only 3 fields: Company, Year, Sales and "stack" the year fields.
Has anyone else tried this? Could you recommend an efficient solution?
A follow up question: I simplified my example a bit - I had actually added a new field to my table in the LOAD statement.
'Auto' as BusinessLine
Now that I have the
CROSSTABLE (.......) Load, the new field doesn't get added properly.
I've addressed this by loading a new table including all fields of the crosstable, adding this new field and dropping the old table. This works, but it makes my code quite long. Is this the only alternative?