Hello
i have two lookup tables
from the first i want to take the field "created_by"
from the second i want to compare the "created_by" fields from the first lookup and check if the field "description" is empty or not.
if empty i want to raise an alert.
How can i join this two lookups?
thanks
So, you can use below;
| inputlookup first_lookup
| lookup second_lookup eventtype as created_by OUTPUT description
| where isnull(description)
If you are getting this error second_lookup has no "eventtype" field. Is it possible a typo?
So, you can use below;
| inputlookup first_lookup
| lookup second_lookup eventtype as created_by OUTPUT description
| where isnull(description)
i'm getting this error:
Error in 'lookup' command: Could not find all of the specified lookup fields in the lookup table.
Hi @sarit_s,
Please try below;
| inputlookup first_lookup
| lookup second_lookup created_by OUTPUT description
| where isnull(description)
Hey,
Thanks for your reply
i think i forgot to mention that in the second lookup the field has different name so for example created_by (from first lookup) has to be equal to "eventtype" from second lookup and then i have to check if description is empty