topic Re: help in script in QlikView

help in script

Mon, 25 Jul 2016 11:03:04 GMT

my requirement is not to load the data(particular row) if a particular field for that row is blank or having blank spaces in it

thanks in advance

Mon, 25 Jul 2016 11:11:03 GMT

You can simply write:

Load * from tablename where len(fieldname)<>0;

Mon, 25 Jul 2016 11:14:16 GMT

Hi,

The script could look like this:

Load field1,

field2,

field3

from ...

where not isnull(field3) and len(trim(field3)) > 0

;

rubenmarin — Mon, 25 Jul 2016 11:15:10 GMT

Hi Nishit, you can use the Index() function to look for a character in a string:

Index(FieldName, ' ') // returns the position where it finds the first blank space; returns 0 if there is none

So you can add the where sentece:

Where Index(FieldName, ' ')=0