Hello,
Say we have test01.csv and test02.csv as source files.
test01.csv is containing IP_Address and name fields
test02.csv is containing IP_Address and Name fields
I need to create a table with the following conditions: For each name events which are empty in test01.csv search the corresponding IP_Address (test01.csv) field, and search that IP_Address in test02.csv and select the Name field, which is always containing values. Then generate a table for all those empty name events and include their IPs and Name fields found.
The search I am performing is the following, but it does not work:
source="test01.csv" OR source="test02.csv" NOT name | transaction "IP Address" | table "IP Address", Name | stats by "IP Address", Name
... View more