how to bring excel sheet names as field

[renjithpl]

Hi All,

I have an excel with 3 sheets, called - Benjamin, Bruno, and Linda

while loading i want those three sheets as a field name called names.

Please help me, it would solve most of my problems.

Thanks

Ren

[#2]

Hope this will work...

Regards,

Nilupa

[#3]

Hi,

If you have many sheets in excel and you want to load them in one go and get the table name, you can connect your excel to qlikview using odbc connection.

for more info have look at this BLOG http://community.qlik.com/blogs/qlikviewblogs/archive/2008/09/29/loading-multiple-excel-sheets.aspx

-Sridhar