How to filter rows Where not start with

[Anonymous]

Hi All ,

I need to filter where Assignment group not start with ML- And UK-ML- then Company= A .

Input:

Company	Assignment group
ISS Europe Limited	UK-ML-Televault
ISS Europe Limited	UK-ML-Televault
Just Energy Corp.	ML-BLR-WINTEL
Just Energy Corp.	ML-BLR-WINTEL
ISS Europe Limited	UK TeleVault Pune
AS	TOC - Backup Tie1
Bank	UK Vytalvault
ISS	UK-ML-Televault
ISS	UK-ML-Televault

Out put:

Company	Assignment group
ISS Europe Limited	UK-ML-Televault
ISS Europe Limited	UK-ML-Televault
Just Energy Corp.	ML-BLR-WINTEL
Just Energy Corp.	ML-BLR-WINTEL
ISS Europe Limited	A
AS	A
Bank	A
ISS	UK-ML-Televault
ISS	UK-ML-Televault

Thanks,

Krishna.

[shraddha_g · Accepted solution]

If(wildmatch([Assignment group],'UK-ML*','ML*'),[Assignment group],'A')

[Chanty4u]

try

load *,

..... from

where not like '*ML*';

or

=aggr(if(NOT WildMatch(Assignmentgroup,'*ML*'),Assignmentgroup), Assignmentgroup)

if it is in script remove aggr

if(NOT WildMatch(Assignmentgroup,'*ML*'),Assignmentgroup)

[Chanty4u]

i thinks it should not widlmatch