Exclude some coloumbs

[Saiteja1]

Hi 
I need some help 

I have data set like this as below

Market, aggregate,value,version

China, region,5,ACT

china, sub region,5,ACT

china,mega region ,5,ACT

china, zone,5,ACT

america,zone,6,ACT

america,sub region,6,ACT

While loading data into script I have to exclude data where market is china and aggregate is region ,sub region,mega region how can I do that 

can anyone please help me 

Thanks in advance

[maxgro · Accepted solution]

X:
load * inline [
Market, aggregate,value,version
China, region,5,ACT
china, sub region,5,ACT
china,mega region ,5,ACT
china, zone,5,ACT
america,zone,6,ACT
america,sub region,6,ACT
]
WHERE
NOT
(
wildmatch(Market, 'china') and match(aggregate, 'region', 'sub region', 'mega region')
)
;

[Saiteja1]

Thanks you  its working @maxgro