Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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....
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
You can drop fields you do not need in the script.
Drop field NameOfFieldYouWantToDrop;
actually i need to drop the Green Clr Highlighted Value in the BackEnd......
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
Hi Narayanan,
Please paste code here so can help.
Regards
Neetha
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
here is the Code.....
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
Ohh really Thank You Soo much Joe....I got that...Thanks alot
if all remaining columns are same expect Database in all 10 tables?