Hi All, The script below loads the data into qlikview file for multiple sheets in a single load by using the Loop statements. LET vStartSheetNumber = 1; LET vEndSheetNumber = 50; LET v...
Hi Folks I have an excel file which I want to convert using cross-table, which I'm happy to do, but the issue that is causing some problems for me is that the columnar data has three heading rows, a...
Hi QC! I am fairly new to Qlikview, and thought I knew what I was doing until I tried to input a table from Excel today. I have a complex excel table, with multiple levels of column headers (ie f...
...iles may have no of worksheets and are not limited in number and may vary from book to book -Name of every sheet in the every excel file is different -In every source excel file only the 1st sheet w...
Hi all, I have a situation where I need to import multiple files into 1 table. The files can have different column headers and some include columns others don't etc. e.g. file 1 might i...
Hi all beloved Qlikers, I will get monthly Excel reports which contain more than 10 sheets. Is there anyways to load all sheets in 1 script? The problem here is there is no header from Sheet 2 o...
Hi all, Can anyone share a good method for loading multiple tables from the same excel tab into QV? Each table has a similar structure except the amount of rows can vary (between 9 and 15) and t...
I'm trying to work with a file that comes from an industrial computer. Before I can import into my Qlik application, I need to figure out how to handle the multipleheader rows and data that u...
Hello, I'm loading multipleexcel files which have a relatively consistent structure. Additional files are generated in the source location regularly. The application which g...