Hi All,
I’m having a really annoying problem with the EXISTS() statement, and I’m going round the bend.
Here’s the set up:
The database I’m working with has somewhere in the neighborhood of 3 million records. The majority of them have no related records in the database, and as a result, I don’t want them clogging up my dashboard.
I’m loading a number of other related objects first in order to create the list of users that I do want in the dashboard, all sharing a field which has been aliased (using the AS keyword) to [Member ID].
In the table I’m loading from, the member ID is called V_ID, and I’m doing this:
LOAD
V_ID as [Member ID],
…
And, at the end of my load statement, I’m attempting to use EXISTS, and it keeps telling me the field doesn’t exist. I’ve tried:
WHERE EXISTS(V_ID, [Member ID]);
WHERE EXISTS(V_ID, “Member ID”);
These two give me ‘Field <Member ID> does not exist’ errors.
I’ve tried a few other more random things that don’t warrant description, to no avail. And the field name has been copied and pasted from the alias in previous tables, so it's not a spelling issue.
It seems like a pretty straight forward thing to do, but it’s not working.
I've also tried scouring the forums, and I see lots of other posts, and people gleefully using exists() in this way, but it doesn't seem to work for me.
Help?
