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

Data filtring

Hi Friends,

I have huge date in below manner, I only required the data begning with the word "Stevedorage_".

what to do ?

Item Description
RECEIVING_EXTRA GATE ALL IN USCHS PER UNIT
DELIVERY_EXTRA GATE ALL IN USCHS PER UNIT
STEVEDORAGE_ LOAD ALL IN CRCAL PER BOX
STEVEDORAGE_ DISCHARGE ALL IN CRCAL PER BOX
STEVEDORAGE LOAD ALL FULL IN PRSJU PER BOX
RECEIVING_EXTRA GATE MOVE ALL Full in USJAX by UNIT
DELIVERY_EXTRA GATE MOVE ALL in USJAX by UNIT
4 Replies
Not applicable

Re: Data filtring

hi,

wile loading all these tales use left( s , n )  function on appropriate field or column and check if that staring starts with "Stevedorage_" and load only those data.

Regards,

Abhishek

Not applicable

Re: Data filtring

Hi,

if your field name is [Item Description] then try this on load script:

load

     *

From table

where [Item Description] = 'Stevedorage_*'

Hope this helps you.

Regards,

Ashutosh

udit_kumar_sana
Contributor II

Re: Data filtring

Hi Neeraj,

You can try like this in the script

Load

*

from table

where wildmatch(itemdescription ,'STEVEDORAGE_*');

Thanks & Regards,

Udit

Not applicable

Re: Data filtring

Use below:

LOAD * FROM table WHERE WildMatch(Fieldmatch,'Stevedorage_*');

Community Browser