Load Multiple excel sheets dynamically without using Macro or ODBC

[nirmalraj_kj]

Hello all,

Herewith attached the source format, is it possible to load in QlikView without using macro or ODBC/OLEDB connection.

Your help is much appreciated.

Please note there might adding more sheets on Ad hoc basis.

Regards

NR

[marcus_sommer]

Not really. If you could add all possible sheetnames within a loop-routine and fetched possible errors with the ERROMODE it might be sufficient for you.

- Marcus

[Anil_Babu_Samineni]

If Sheets are static then Use Concatenate like

tables:

LOAD * FROM (ooxml, embedded labels, table is Chennai);

Concatenate(tables)

LOAD * FROM (ooxml, embedded labels, table is Bangalore);

Concatenate(tables)

LOAD * FROM (ooxml, embedded labels, table is Mumbai);

Concatenate(tables)

LOAD * FROM (ooxml, embedded labels, table is Delhi);

Concatenate(tables)

LOAD * FROM (ooxml, embedded labels, table is Pune);

Concatenate(tables)

LOAD * FROM (ooxml, embedded labels, table is Hyderabad);

Or, If dynamic you could use For Each loop Loading Multiple Excel Sheets Dynamically along with file name and sheet name

[nirmalraj_kj]

Hi Anil,

Thanks for your response, I have mentioned in my question that we have to load the data dynamically rather using ODBC/OLED or Macro.

and I mentioned there might add some more sheets in future in that case how can we write concatenate. This is not a dynamic way.

Regards

Nirmal

[nirmalraj_kj]

Thanks for your reply Marcus,

That is not possible in my case I have more that 50 sheets and it might increase in future. I have to load this dynamically without changing code.

[Anil_Babu_Samineni]

That's why I have initiated Plan B for you

[nirmalraj_kj]

You mean using ODBC?

[Anil_Babu_Samineni]

Not exactly, But how your source stored? In DB / Flat files?

[nirmalraj_kj]

Excel spread sheet...

[marcus_sommer]

You need to know (or at least to guess the possible sheetnames) or using odbc/macros to keep the loadings dynamically. Maybe the citys which are used as sheetnames are also stored anywhere else from which it could be read ...

- Marcus