How do I pass through where not Exists in ProductName table.
LOAD *, ResourceID as Value
DROP TABLE ProductNameTemp;
LOAD *, ResourceID_1 as Value_1
DROP TABLE UsersTemp;
Load ProductName, LastUsage, '' as Netbios_Name0, '' as User_Name0, ResourceID
where not Exists(Value, ResourceID_1);
Load ProductName, '01/01/1981' as LastUsage, Netbios_Name0, User_Name0, ResourceID_1 as ResourceID
where not Exists(Value_1, ResourceID);
I am not able to understand what you want to do. As per my understanding first you want to load ProjectName and User tables without any where clause. Then why do you again want to load productName table with where not exist clause.
As per documentation the exist clause syntex is:
exists(field [ , expression ] )
Determines whether a specific field value exists in a specified field of the data loaded so far. Field is a name or a string expression evaluating to a field name. The field must exist in the data loaded so far by the script. Expr is an expression evaluating to the field value to look for in the specified field.
Please explain in detail what do you want to do.