Double condition and not match

[#1]

Hi there,

Im using the not match function to exclude datas from my load. Works fine:

FROM

(ooxml, embedded labels, header is 2 lines, table is sheet1)

Where not Match (Catégorie,'62','67','68')

Ok, now I want to add an other condition:

Where not Match (Dir.,'D0033')

I cannot figure out how to combine both... Aby ideas?

Thanks

[lorenwood · Accepted solution]

Hi Try:

FROM

(ooxml, embedded labels, header is 2 lines, table is sheet1)

Where not Match (Catégorie,'62','67','68') and not Match (Dir.,'D0033')