i have 2 excel files in which it has 2 sheets each....
i want to load both of them at a tym.
in 1st excel file
1st sheet is
d sheet is
In 2nd excel seet we have
1st & 2nd sheet is
i want to load both the excel files using for loop?Plzzzzzzzzzzzzzzzzz helpppppppppppppppppppppppp
write the scripting code plssssss
take a look at this :
// SUBPROGRAM : all xls files in repository
//Récupération des fichiers enquête
FOR Each File in filelist (Root&'\TEST*.xls' )
IF FileSize('$(File)') > 0 then
(biff, embedded labels, table is Feuil2$);
//Exécution du sous programme
CALL ListeEnquetes ('\\SRV\TEST')
The code is in English and perfectly understandable. The only thing not in English are the name of the SUB and the name of the table; they will work perfectly even when not in English.
Just copy-paste it and replace the none-code words by the names of your files, sheets and (table and sub) naming convention .
If you have any specific questions left, please let us know.
If not, please flag the topic as answered.
1st excel file name is :Excel1
in that the sheet names are Sheet1 and Sheet2
2nd excel file name is : Excel2
in this file,the sheets are Sheet1 and Sheet2
Im new to qlik view....
Please write the exact code and i will copy paste
and i will run......
Waiting for the reply
Assuming the sheets have the same columns (which don't even have to be in the same order), the different sheets will automatically concatenate.
Did you try it?