join two lookup tables

[sarit_s]

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

[scelikok]

If you are getting this error second_lookup has no "eventtype" field. Is it possible a typo?

[scelikok · Accepted solution]

So,  you can use below;

| inputlookup first_lookup
| lookup second_lookup eventtype as created_by OUTPUT description
| where isnull(description)

[sarit_s]

i'm getting this error:
Error in 'lookup' command: Could not find all of the specified lookup fields in the lookup table.

[scelikok]

Hi @sarit_s,

Please try below;

| inputlookup first_lookup
| lookup second_lookup created_by OUTPUT description
| where isnull(description)

[sarit_s]

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