Reading Multiple Excel files along with table names using loop statement

MEDHA07 — Fri, 15 Nov 2024 21:10:19 GMT

FileList:
LOAD * INLINE [
    FileName, TableName
    REGION.XLS, REGION$
    DIVISION.XLS, DIVISION$
];


FOR i = 0 TO NoOfRows('FileList') - 1

    LET FileName = peek('FileName', i, 'FileList'); 
    LET TableName = peek('TableName', i, 'FileList'); 

    div_reg_table:
    LOAD
        *
    FROM '$(FileName)'
    (biff, embedded labels, table is '$(TableName)');

NEXT

Re: Reading Multiple Excel files along with table names using loop statement

rubenmarin — Sat, 16 Dec 2023 08:22:06 GMT

Hi, is this a question or hint? If it fails it migh be because if the excel is in another folder of the QVW it will need the path for the excel.

topic Reading Multiple Excel files along with table names using loop statement in App Development

Reading Multiple Excel files along with table names using loop statement

Re: Reading Multiple Excel files along with table names using loop statement