Discussion Board for collaboration on QlikView Scripting.
Maybe this might have been asked/answered before, but here's the issue I'm having :
does not seem to concatenate the excel files while I have seen similar code work in concatenating *.qvd files. With the above code, the data goes into a new table for each file.
Any ideas on what/how I could change the code for concatenation? Thanks.
Hi, you forgot mention the Sheet on the load statement, is this just an example?
Yup, this is just an example. In my code I do have the sheet name :
are there an identical number of columns, and are they named the same? -- they need to be for QV to auto-concatenate.
Yes they are. I managed to get the concatenation to work by simply using :
FOR EACH file in filelist and then,
placing a CONCATENATE before the LOAD statement
But I find that the data is not loaded into the table (Report) that I specified. Here's the example code :