Geneos - Gateway - How to filter out null values in Gateway SQL

Use the "" syntax

If the source table for a Gateway SQL query has null values and you would like to filter these out, you can use the query:

select * from T1 where ID <> ""

where T1 is the source table.

T1:

Resulting dataview in gateway sql sampler: