My dashboard data source is Excel files. The names of those excel are like Alpha012018, Alpha032019, Alpha052019
Alpha012018, Alpha032019 had columns A, B ,C and dashboard was working fine. Now I have a request to add one more column in Alpha052019 like A, B ,C, D and load the data for all the files. (Additional column to excel)
for each file in FileList('yourPath') //Your path where the excel file is stored example 'D:\test\test\test.xlsx'
ODBC CONNECT32 TO [Excel Files;DBQ=$(file)];
FOR i = 0 to NoOfRows('tables')-1
LET sheetName = purgeChar(purgeChar(peek('TABLE_NAME', i, 'tables'), chr(39)), chr(36));
'$(sheetName)' as Sheet // Optionally, the sheetName value may be loaded as a field
FROM $(file) (ooxml, embedded labels, table is [$(sheetName)]);
I tried it with the excel example and .qvw file attached below.