topic do not load empty data in QlikView

do not load empty data

cscherer — Thu, 27 Sep 2012 07:20:40 GMT

Hello,

I`ve got lots of .csv-files, which are my data sources. In some files there are empty rows - but there is a separator. In a listbox I see them as empty data.

What do I have to do to not load the empty rows? How does the script has to look like?

Thanks in advance,

cscherer

Re: do not load empty data

jonathandienst — Thu, 27 Sep 2012 07:43:33 GMT

You can create a filter using the 'Enable Transformation Steps' option in the load wizard. Use conditional delete to exclude lines that meet criteria that you specify (eg exclude lines where column 1 is empty).

If you post a sample of the text file, then someone can be more specific about the filter that you need.

Hope that helps

Jonathan

Re: do not load empty data

hic — Thu, 27 Sep 2012 07:58:29 GMT

The simplest way is to have a where clause:

Load ... From ... Where Len( <Column1> ) > 0 ;

HIC

Re: do not load empty data

cscherer — Thu, 27 Sep 2012 08:11:52 GMT

thanks, it works!