Removing row from excel on load

[bobbydave]

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.

[bobbydave · Accepted solution]

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)