exclude value

[mambi]

Hi,

i have 2 tables :

ALLProducts:
LOAD * INLINE [
     id, name,category
     10, Product1,2
     11, Product2,3
     12, Product3,2
     13, Product4,1
];


BannedProducts:
LOAD * INLINE [
     id, name,category
     10, Product1,2
];
 

i want to get only the list of products that are nor banned

i tried where not exists but doesn't work , is there any other function ?

any idea ?

[Anonymous]

First, load the table of the banned products, after that load the table of all products with condition

where not exists(id)

After that, you can drop the table of banned products.

Regards,

Michael

[tresesco]

the script would look something like:

BannedProducts:
LOAD * INLINE [
     id, name,category
     10, Product1,2
];

ALLProducts:
NoConcatenate
LOAD IF(not Exists(id),id) as id, name, category INLINE [
     id, name,category
     10, Product1,2
     11, Product2,3
     12, Product3,2
     13, Product4,1
];

Drop Table BannedProducts;

[mambi]

Don't work !

[mambi]

Work but still have Product1 in the list of ALLProducts

[Anonymous · Accepted solution]

It sure works:

BannedProducts:

  LOAD * INLINE [
     id, name,category
     10, Product1,2
];

ALLProducts:
NoConcatenate
LOAD
*
where not exists(id)
;
LOAD * INLINE [
     id, name,category
     10, Product1,2
     11, Product2,3
     12, Product3,2
     13, Product4,1
];

Drop Table BannedProducts;

[mambi]

Thank's a lot sir

[Anonymous]

No problem.  You possibly missed something small first time...

[mambi]

What's if i would like to keep the BannedProducts to compare categories? reload it again?

[tresesco]

this?

................

ALLProducts:

NoConcatenate

LOAD id, name, category INLINE [

     id, name,category

     10, Product1,2

     11, Product2,3

     12, Product3,2

     13, Product4,1

] where not Exists (id);