When the wizard opens and you choose your Excel file, click on the "Transform" button and you can select rows to always delete, like the first three and you can create a conditional delete, so for the last row the conditional delete says to delete and column with "Genereate at" in it.
Thanks for your help. But I think I haven't explained my problem enough. I got nearly the same code as you, but the thing is, I can't use the excel output from "Jira", it is not recongnized as a excel file in the script editor wizard. I can only use it when I open it before manually within Excel and convert it to a normal excel file. I think markmccoid also have converted into a right excel with the name DELETE.xls
Please look at the screenshots. The thing is this that everything should be automatically, the file is saved automatically somewhere and qlikview imports it than automatically, but it should be not like this that I must convert the excel format.
I don't know exactly which type of excel output it is, a little bit strange.
Is it also possible to import the data without change of the rare data file?
I have the same question as Matthew Johnson. Please update if there is any way to connect JIRA data directly or through third party into Qlikview. We have been currently exporting from JIRA and then importing into Qlikview. It becomes too tedious as we can't do live reporting.
Not sure if this method would be the way to go, but you can try connecting JIRA to MySQL. By doing this you can download the issues, tasks etc data into MySQL and connect to Qlikview to load data and create reports using the OLE DB connection. I haven't tried it.