topic Re: Loading Multiple Excel Sheet in QlikView

Loading Multiple Excel Sheet

Wed, 25 Feb 2015 09:44:13 GMT

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....

Re: Loading Multiple Excel Sheet

oknotsen — Wed, 25 Feb 2015 09:48:42 GMT

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

Drop field NameOfFieldYouWantToDrop;

Re: Loading Multiple Excel Sheet

Wed, 25 Feb 2015 09:57:00 GMT

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

Re: Loading Multiple Excel Sheet

Wed, 25 Feb 2015 10:23:04 GMT

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

Re: Loading Multiple Excel Sheet

Anonymous — Wed, 25 Feb 2015 10:25:29 GMT

Hi Narayanan,

Please paste code here so can help.

Regards

Neetha

Re: Loading Multiple Excel Sheet

prieper — Wed, 25 Feb 2015 10:41:38 GMT

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

Re: Loading Multiple Excel Sheet

Wed, 25 Feb 2015 10:55:16 GMT

here is the Code.....

Re: Loading Multiple Excel Sheet

Wed, 25 Feb 2015 11:01:41 GMT

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

Re: Loading Multiple Excel Sheet

Wed, 25 Feb 2015 11:18:10 GMT

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

Re: Loading Multiple Excel Sheet

vinay_hg — Wed, 25 Feb 2015 11:18:57 GMT

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