do not load empty data

[cscherer]

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

[jonathandienst]

Hi

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

[hic · Accepted solution]

The simplest way is to have a where clause:

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

HIC

[cscherer]

thanks, it works!