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,
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.
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.