Removing row from excel on load

bobbydave — Fri, 20 Nov 2020 18:02:30 GMT

hi guys,

Maybe a tricky question. Not sure if it can be done.

I have an excel stats document that I am loading. However, on the document, it has a field when the report is generated that shows the created date in one of the rows. As you can imagine, when the stats document is loaded into excel, it has the row of data as is and a created: theDateAndTime.

I don't want to bring in the created date. I also had a TOTAL (COUNT) in the row which I removed by using an if statement to say,

if (row <> 'TOTAL (COUNT), show the rest of the data.

But with Created: theDateAndTime , the Date and Time are dynamic depending on when I pulled the report.

Anyone encountered this?

Help appreciated.

If all comes to all, I can have the person remove TOTAL (COUNT) and Created Date before the files are even loaded in Qlikview.

Re: Removing row from excel on load

bobbydave — Thu, 11 Jun 2015 07:43:42 GMT

Not to worry, I used the wildcard match function and have it now fixed.

if(WildMatch(myGroup, 'whatIamLookingFor'), myGroup)

This only showed what I wanted it to show and also removed the Created Date and Total(count)

topic Re: Removing row from excel on load in QlikView

Removing row from excel on load

Re: Removing row from excel on load