Delete Rows dynamically from excel

[agni_gold]

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

[maxgro]

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

Where Len(Information) = 1

[agni_gold]

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

[Clever_Anjos]

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)

[deepakqlikview_123]

You can use folter where <>  condition in load statement

[Anonymous]

Hi,

Try this

In Script editor,

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

o/p: