Issue with ODBC connection for Excels

[komminenianusha]

Hi All,

I am working on qlikview to qliksense migration of dashboards. Here I am facing issue with ODBC connection for excel files.

In qlikview had a sub routine to load all excels in a folder at a time. I need to replicate same subroutine in qliksense.

Please any one help me for getting this. Very urgent requirement please help me.

Below is the code used in qlikview

LET repertoire='\\corporate\Cons\Construction\monthly report\';

SUB DoDir2 (Root2)
FOR each File IN filelist (Root2&'*.xlsx')     

 
ODBC CONNECT To [Excel Files;DBQ=$(File)];

filedata:
load * ;
SQLTABLES;
next File
FOR each Dir2 in dirlist (Root2&'\*')
CALL DoDir2(Dir2)
NEXT Dir2

END SUB
CALL DoDir2('$(repertoire)')

DISCONNECT;

Thanks in advance.

Regards,

Anusha

[komminenianusha]

Please anyone respond on this issue. Its very urgent.

[komminenianusha]

No one worked on this?

[manoj217]

Qlik Sense - Load all files from a folder

[manoj217]

LOAD * FROM

'lib://DataSource/Customers/*.xlsx;

[manoj217]

SUB DoDir (Root)

FOR each File in filelist(Root& '\*.xls')

LOAD

value1,

value2,

value3

FROM [$(File)] (biff, embedded labels); //by leaving the part of naming the table it uses all tables of the file

NEXT File

FOR each Dir in dirlist (Root&'\*')

CALL DoDir(Dir)

NEXT Dir

END SUB

CALL DoDir('c:\test')

Try this