I have a list of items and I need to split each of the items by a delimiter to convert that to a list.
<code>let apps = ['a', 'a.b.c']
...
SummaryTable
| where column has(apps)
</code>
<code>let apps = ['a', 'a.b.c']
...
SummaryTable
| where column has(apps)
</code>
let apps = ['a', 'a.b.c']
...
SummaryTable
| where column has(apps)
Note:
If all the parts of an item from the dynamic list are present in the column
then it is match. (I need to compare it with all the items in the list)
- If the
column
hasa
– It is a match. - If the
column
hasa
,b
andc
– It is a match. - If the
column
hasb
– It is not a match.