Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist III

Delete Rows dynamically from excel

Hi Friends ,

I have one excel attached , and i dont want to load Yellow lines , but these yellow lines not static , these may be vary.

Is there way to do this

Tags (1)
5 Replies
Highlighted
MVP
MVP

Re: Delete Rows dynamically from excel

In load script, it seems you can filter the Information values

Where Len(Information) = 1

Highlighted
Specialist III
Specialist III

Re: Delete Rows dynamically from excel

Thanks but information column values are dummy , they might other values also.

Highlighted
Employee
Employee

Re: Delete Rows dynamically from excel

Qlikview load process does not have access to Excel formats (like yellow).

You should choose another criteria to not retrieve a line (a value, an empty column, etc)

Highlighted
Specialist
Specialist

Re: Delete Rows dynamically from excel

You can use folter where <>  condition in load statement

Highlighted
Partner
Partner

Re: Delete Rows dynamically from excel

Hi,

Try this

In Script editor,

Table files->open->next->Enable Transformation Step->Garbage->Conditional delete->Specify column as 2 is empty->add->ok.

capt.PNG

o/p:

Capt2.PNG