extract ID's which is not match

capriconuser — Tue, 12 Jan 2021 10:04:21 GMT

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 ?

topic extract ID's which is not match in Connectivity & Data Prep