Skip to main content
Solved

Issues with data tables while mapping a corresponding string

  • Sep 18, 2025 7:56 PM UTC
  • 1 reply
  • 160 views

Forum|alt.badge.img+1

I have a data table with the following data,

regex_exp {REGEX} app {STRING}
.*s3\.amazonaws\.com.* Amazon
.*storage\.live\.com.* Microsoft


Now, my requirement is that when ever the “regexexp” matches as mentioned, it should replace the variable($new_app) with the corresponding string in the “app” column.

I tried using the below expression, even though it’s not showing any error, but upon execution it’s failing (generic::unknown)

$new_app = array_distinct(re.replace(target.url, %Cloud_Services.regex_exp, %Cloud_Services.app))

Has anyone solved similar issue ? Is there any other way to solve the same ? Any leads on it will be really helpful. 

Thank You.

Best answer by JeremyLand

The query format for joining your events to the data table so the app column will be accessible is 
re.regex(target.url, %Cloud_Services.regex_exp)

You don’t need to address a re.replace or even mention the app column, once you have that join in place you will be able to select the ‘app’ column from the column selector.

In this example I have named the data table Example_AppNames.

 

Building on that basic requirement you can force the column to be automatically included in search results by including $app=%Cloud_Services.app you your query.


However there is a big caveat with pulling this info back from a data table.  This is an INNER JOIN so any event where target.url does not match a regex in your table will be excluded from your results.  

​​​​

View original

1 reply

JeremyLand
Staff
Forum|alt.badge.img+8
  • Staff
  • Answer
  • Sep 22, 2025 10:56 PM UTC

The query format for joining your events to the data table so the app column will be accessible is 
re.regex(target.url, %Cloud_Services.regex_exp)

You don’t need to address a re.replace or even mention the app column, once you have that join in place you will be able to select the ‘app’ column from the column selector.

In this example I have named the data table Example_AppNames.

 

Building on that basic requirement you can force the column to be automatically included in search results by including $app=%Cloud_Services.app you your query.


However there is a big caveat with pulling this info back from a data table.  This is an INNER JOIN so any event where target.url does not match a regex in your table will be excluded from your results.  

​​​​