Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loading Multiple Excel Sheet

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

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

9 Replies
oknotsen
Master III
Master III

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

Drop field NameOfFieldYouWantToDrop;

May you live in interesting times!
Not applicable
Author

DATABASE.PNG

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

Not applicable
Author

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

neetha_p
Master
Master

Hi Narayanan,

Please paste code here so can help.

Regards

Neetha

prieper
Master II
Master II

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

Not applicable
Author

Detail.PNG

here is the Code.....

Not applicable
Author

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

View solution in original post

Not applicable
Author

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

vinay_hg
Creator III
Creator III

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