Loading Multiple Excel Sheet

[#1]

Hi to all....

                Actually i Have uploaded all the excel sheets in the Qlikview using for loop..but the thing is am getting one SubField Call 'DATABASE' in SheetName..But i don't have any Sheet Name like that in my Excel....and AM getting all the Sheet values in that subfield....so the data is Duplicating One more Time....How can i Remove that Sub Field In the Script....Pls its urgent..

I used ODBC Connection String to extract the Excel File From the database...

Thanks in advance....

[oknotsen]

You can drop fields you do not need in the script.

Drop field NameOfFieldYouWantToDrop;

[#3]

actually i need to drop the Green Clr Highlighted Value in the BackEnd......

[#4]

Probably a hidden sheet that is being picked up in your loop. Can just add a condition on each loop to load where the sheetname isn't Database.

post your code/ example app if you need more help on that

hope that helps

Joe

[Anonymous]

Hi Narayanan,

Please paste code here so can help.

Regards

Neetha

[prieper]

guess that you work with a construct basing on SQLTABLES, so you may modifiy your script like

in the below script:

http://community.qlik.com/message/546602#546602

HTH Peter

[#7]

here is the Code.....

[#8 · Accepted solution]

Change you temp table slightly to filter out the sheetname you don't want.

Temp_List:

SQLTables;

Temp_Tables:

Noconcatenate

Load TABLE_NAME

Resident Temp_List

Where Not Match(TABLE_NAME,'Database');

Drop Table Temp_List;

something like that

Joe

[#9]

Ohh really Thank You Soo much Joe....I got that...Thanks alot

[vinay_hg]

if all remaining columns are same expect Database in all 10 tables?