Load multiple files from SmartSheet

[madhubabum]

Hi All,

I have multiple files with in "Smartsheet Database "

Ex: Smartsheet_2016_01,

      Smartsheet_2016_02,

      Smartsheet_2016_03,

      Smartsheet_2016_04,.........etc

I want to load multiple files with in loop ?  ( Smartsheet_2016* )

How we can load smartsheet files with in loop ?

Any Help ?

Regards,

Madhu

[arulsettu]

check this

Loading Multiple Excel Sheets Dynamically along with file name and sheet name

Load Multiple excel sheets using For loop

[qlikview979]

Hi Try This,

For each Vpath in FileList('D:\Personal\MULTIPLE\*.xlsx');

T1:

LOAD id,

    name,

    date

FROM

[$(Vpath)]

(ooxml, embedded labels, table is [$(*)]);

NEXT Vpath;

Regards,

Mahesh

[madhubabum]

Hi Mahesh Kumar,

Thanks for your reply

In my scenario , My data is in Database ..

EX:

LOad *;

SQL SELECT *

FROM "Smartsheet_2016*";

[p_verkooijen · Accepted solution]

Connect to the SQL server.

TempTables:

LOAD *; SQLTABLES;

TableNames:

LOAD TABLE_NAME

RESIDENT TempTables

WHERE LEFT(TABLE_NAME, 10)='Smartsheet';

DROP TABLE TempTables;

FOR i = 1 TO (NOOFROWS('Tables'))

  LET vTableName = TRIM(FIELDVALUE('TABLE_NAME', '$(i)'));

  Smartsheet:

  LOAD *;

  SQL SELECT *

  FROM $(vTableName);

NEXT