hide empty line

[#1]

hello,

I have a document witch shows article info, the field ftplink shows a link to a document, in some cases the are 2 rows for an article.

the empty row dont needed te be loaded.

I already tried the where statement however it is not the same value. can i use somthing like ftp://*

[Ralf-Narfeldt]

Do you want to discard all lines where ftplink contains ftp:// ?

In that case

Load

....

Where SubStringCount(ftplink, 'ftp:') = 0;

[#3]

I want to hide all empty rows en and show all rows witch contain 'ftp://*'

[Ralf-Narfeldt]

Then it's:

Load

....

Where SubStringCount(ftplink, 'ftp:') > 0;

[#5]

getting an error

[sasiparupudi1 · Accepted solution]

try like this

temp:

sql select

     Nummer,

     Tekst

from "PRODUCTIE DATA".Vertaal;

final:

load

Nummer,

     Tekst

resident temp

where wildmatch(ftplink, 'ftp://*')>0;

drop table temp;

[Ralf-Narfeldt]

Yes, you can't use the SubstringCount function in the SQL Select, it needs to be done in a preceding Load, or a Resident load like Sasidhar showed.

But you wrote that there was a field called ftplink, and in your example you load fields Nummer and Tekst, so Sasidhar's example won't work either.

In which field is the ftp address?

[qlikviewwizard]

Can you please attach the sample file to fix the issue quickly? Thank you.