Why doesn't search return result when I list a field of a lookup?

[juanda667]

I was trying to join a group of documents with a list of users that I had in a lookup, and the search return me results and always works fine, but the problem its when I try to table another of the fields of the lookup. The search that return me one result, doesn't return me nothing, and I cant understand why, cause the table doesn't should affect the results or the search.

Even I try to change the name or different things like list the lookup and search the documents, but simply doesnt work

this is when I try to table "Nombre", the search doesn't return results

But this is exactly the same search and if I dont put the field "Nombre" , return me results

this is the lookup, and if I search the document that match in the join, I see that effectively have the field "Nombre"

In all the searches have a range of 7 days ago,

[bowesmana · Accepted solution]

If you have a lookup and you want to get data from the lookup into a data stream, use the lookup command, not join.

You should almost never need to use join.

Use

| lookup VIP_Empleados.csv LOOKUP_FIELD as DATA_FIELD OUTPUT wanted_fields

You can then test if the fields you want from the lookup are null (no match found) or present.