topic Delete Rows dynamically from excel in QlikView

Delete Rows dynamically from excel

agni_gold — Sat, 10 Dec 2016 08:20:00 GMT

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 — Sat, 10 Dec 2016 08:51:26 GMT

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

Where Len(Information) = 1

agni_gold — Sat, 10 Dec 2016 08:55:27 GMT

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

Clever_Anjos — Sat, 10 Dec 2016 12:18:27 GMT

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 — Sat, 10 Dec 2016 13:04:06 GMT

You can use folter where <> condition in load statement

Anonymous — Thu, 20 Sep 2018 06:20:15 GMT

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: