Filter Variable

Hi,

While importing, I’m trying to filter out any categories which hold a specific keyword like “Apple”.

The category path in the import file would be something like Fruits>Apple>Green

xpath looks like or category_path[1][not(contains(.,"Apple"))]

Unfortunately this still imports the Apples. Do I need to use some variable and if so, how?

Thanks!