topic Re: Exclude some coloumbs in Qlik Automate

Exclude some coloumbs

Saiteja1 — Thu, 18 May 2023 09:06:35 GMT

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

Re: Exclude some coloumbs

maxgro — Thu, 18 May 2023 10:17:56 GMT

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')
)
;

Re: Exclude some coloumbs

Saiteja1 — Thu, 18 May 2023 10:42:27 GMT

Thanks you its working @maxgro