This content has been marked as final. Show 2 replies
I am loading a crosstable from excel with a pretty typical format. Across the top I have cities, and along the side I have measures. I'd like to be able to write my script in such a way that as new cities are added to the spreadsheet, I don't need to rewrite the load script. Is this possible?
Excel file looks something like this:
Script looks something like:
FROM .\data.xlsx (ooxml, embedded labels, table is Sheet1);