topic Re: Load multiple files from SmartSheet in QlikView

Load multiple files from SmartSheet

madhubabum — Tue, 12 Jul 2016 09:05:18 GMT

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

Re: Load multiple files from SmartSheet

arulsettu — Tue, 12 Jul 2016 09:09:28 GMT

check this

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

Load Multiple excel sheets using For loop

Re: Load multiple files from SmartSheet

qlikview979 — Tue, 12 Jul 2016 09:21:43 GMT

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

Re: Load multiple files from SmartSheet

madhubabum — Tue, 12 Jul 2016 10:10:16 GMT

Hi Mahesh Kumar,

Thanks for your reply

In my scenario , My data is in Database ..

EX:

LOad *;

SQL SELECT *

FROM "Smartsheet_2016*";

Re: Load multiple files from SmartSheet

p_verkooijen — Tue, 12 Jul 2016 11:04:53 GMT

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);