Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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
Author

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
Creator II
Creator II

Hi Neeraj,

You can try like this in the script

Load

*

from table

where wildmatch(itemdescription ,'STEVEDORAGE_*');

Thanks & Regards,

Udit

Not applicable
Author

Use below:

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