Discussion Board for collaboration on QlikView Scripting.
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://*
Go to Solution.
try like this
from "PRODUCTIE DATA".Vertaal;
where wildmatch(ftplink, 'ftp://*')>0;
drop table temp;
Do you want to discard all lines where ftplink contains ftp:// ?
In that case
Where SubStringCount(ftplink, 'ftp:') = 0;
I want to hide all empty rows en and show all rows witch contain 'ftp://*'
Where SubStringCount(ftplink, 'ftp:') > 0;
getting an error
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?
Can you please attach the sample file to fix the issue quickly? Thank you.