Transform Field lookup not work

Hi.

In Graphan there is such a parameter in the transformation as “Field lookup”. I have a field that contains the client’s IP address. I transform this field with “Field lookup” and specify that it transforms it into “Countries”. But nothing happens. Do I need to set something extra?

hello

ip.address
10.1.10.11

countries
usa
somalia
australia

Nothing will happen in this scenario as there is no correlation. Unless I am missing something? If so could you please provide data sample?

Here is the Traefik Access log. It has the client address in the “client” column.

image

The transformation looks like this

Query

One more question right away. Is it possible to create a custom column and re-populate some custom values into it? For example, I can get the client’s country, or any other value, can this value be redirected to a separate column? Is it possible to get the country from external sources via API?