find new items

[gidon500]

Hi

i have to 2 lists of items , I need to find the new ones , that are not available on the other list .

enclosed is a file

sheet list1 is long list that includes all

sheet list2 is short list

sheet list3 is the list I want to get

those are the iitems that are on list1 and not on list2

thanks

gidon

[swuehl]

You can use EXISTS() function for that:

LOAD item, desc, 'Old' as Status FROM list2;

LOAD item, desc, 'New' as Status FROM list1 WHERE NOT EXISTS(item);

This will create a single table with a status field, if you just want to create list3 table

OLD:

LOAD item, desc FROM list2;

list3:

NOCONCATENATE LOAD item, desc FROM list1 WHERE NOT EXISTS(item);

DROP TABLE OLD;

[mambi · Accepted solution]

try this :

B:
LOAD * INLINE [
item,desc
100,PC
103,BLUE-NB
];
 

A:
load item,desc, if(Exists(item),1,0) as flag;
LOAD * INLINE [
item,desc
100,PC
101,NB
103,BLUE-NB
104,SERVER
];