extract ID's which is not match

Ask a Question

I have script like this

sheet:
LOAD 
      
     SubField(Task, ' ',1) as Task_ID,
     Task
FROM
data\SHHET1.xls
(biff, embedded labels, header is 6 lines, table is [All Projects$]);

data:
LOAD 
      
     SubField(Task, ' ',1) as Task_ID,
     Task_Name
FROM
data\data.xls
(biff, embedded labels, header is 6 lines, table is [All Projects$]);

Now there is some Task _ID in data which is not in SHHET1 ...

and I want extract those ID's

I don't want to do in script.. how I do that in expression ?

0 Replies