Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
In load script, it seems you can filter the Information values
Where Len(Information) = 1
Thanks but information column values are dummy , they might other values also.
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)
You can use folter where <> condition in load statement
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: