Try a CROSSTABLE LOAD prefix, something like
CROSSTABLE (Year, Sales,1) LOAD * FROM YourTable;
Check the Help for more details on CROSSTABLE.
To make this work, your input fields need to be in order: Company, 1990, 1991, 1992, ...
i.e. Company should be first in order when loading from your source. You may need to specify your field order explicitely, if needed.
Thank you! This worked.
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?