It says in the Lookup object help file:
"The tokens generated by the Lookup process can be used to fill out document metadata such as document name, folder path, and fields."
The lookup object creates a token in testing but the lookup objects are ignored in the token dialog. So how would you ever get the result of the lookup into the metadata fields?
This is the lookup object
Here you can see it generates a token
But since Lookup objects are always filtered out of the token dialog, where would I ever be able to use this data?
Your never going to be able to access any of your lookup activities in this menu
Or this menu
Update: I just remembered that you must select which columns your query is going to return before you write the query. The documentation does not mention this at all, it even says selecting a table and columns OR writing your own custom query which is not true.
This is not like workflow where you can just write the query, then test, then access the resulting column data as tokens.
I still have the same problem though, because we are querying from something that is not in the list of tables.