Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

hide empty line

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.

Knipsel.JPG

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://*

1 Solution

Accepted Solutions
sasiparupudi1
Honored Contributor III

Re: hide empty line

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;

7 Replies
Employee
Employee

Re: hide empty line

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

In that case

Load

....

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

Not applicable

Re: hide empty line

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

Employee
Employee

Re: hide empty line

Then it's:

Load

....

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

Not applicable

Re: hide empty line

Knipsel.JPG

getting an error

sasiparupudi1
Honored Contributor III

Re: hide empty line

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;

Employee
Employee

Re: hide empty line

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?

Arjunarao
Honored Contributor II

Re: hide empty line

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

Community Browser