Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
];
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;
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
];