where condition in a script

[mario-sarkis]

hey guyz please help

i have a field lets say

SEGMENT:

employee
Mass

Upper Mass

Loyal

i need to extact this field but in condition to be diffrent then employee and Mass

How can i write it in a script

[PrashantSangle]

Hi,

Can you explain in details??

Regards

[jagan]

Hi,

Try like this

LOAD

*

FROM DataSource

WHERE NOT WildMatch(SEGMENT, 'employee', 'Mass');

Hope this helps you.

Regards,

Jagan.

[ashfaq_haseeb · Accepted solution]

Hi,

Try like this

Load * where not WildMatch(SEGMENT,'*employee*','*Mass*');

load * Inline

[

SEGMENT

employee

Mass

Upper Mass

Loyal

];

Regards

ASHFAQ

[#5]

SEGMENT:

Load employee from tablename where employee <>'Mass'