Dear all,
we have data in several excel files that have different number of columns - but the greatest number is 11. So we set our load procedure to be the same for all files:
LOAD @1, @2,@3, @4, @5, @6, @7, @8, @9, @10, @11
FROM [FileName.xls] (biff, no labels, table is Sheet1$);
We thought that this would load all the data from the full files with 11 columns and load Nulls or 0 for the last columns of files that have less than 11 columns with data. To our surprise excel loads data for such empty columns! Please check the attached Xls file and QVW that loads the first 11 columns from it.
How can we fix this so that not to load such ghost data?
Thank you.
