When importing an Excel file with the “extract column names“ option checked, it omits columns without data

1

Given this Excel document:

image
image1828×682 38.3 KB

When I create an XLS format with the Extract Column Names option checked,

then there is no “Nov” column in the resulting virtual dataset.

Is this expected behavior? Any thought on how to best address this?

In subsequent query on this dataset, I do an unpivot on the month names, and it is really annoying if month columns are missing.

In the example dataset, all other columns are imported successfully.

2

@serra Yes, that is expected behavior now, I tried a quick example to test. Is thhis a static file, then can you format it with the columns and then remove the first line again?

3

OK, I will pre-process the file with using a script then. Thank you for confirming.

4

@serra Welcome! Please reach out for any additional questions!