This content has been marked as final. Show 4 replies
I want to load the data dynamically from the files likes Sales Data - 2015.xlsx,Sales Data - 2016.xlsx.
Need to load the first sheet name is like Sales Data - 2015,Sales Data - 2016.
Last two columns in the files are with Year names like Sales 2015,Sales 2016.
Please check the attached file.
I want to do like this but not sure how to achieve .
LOAD ColumnA as Ename,
ColumnB as Year,
ColumnC as Month,
ColumnD as Sales,
ColumnE as Target
[ExternalData\Excel\Sales Data - 2015.xlsx]
(ooxml, embedded labels, table is [Sales-2015]);