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:
CrossTable(London, Data) LOAD F1, London, Dublin, Toronto FROM .\data.xlsx (ooxml, embeddedlabels, tableis Sheet1);