I have huge date in below manner, I only required the data begning with the word "Stevedorage_".
what to do ?
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.
if your field name is [Item Description] then try this on load script:
where [Item Description] = 'Stevedorage_*'
Hope this helps you.
You can try like this in the script
where wildmatch(itemdescription ,'STEVEDORAGE_*');
Thanks & Regards,
LOAD * FROM table WHERE WildMatch(Fieldmatch,'Stevedorage_*');
Retrieving data ...