How to use database query data with data transformations?

@Teodor, can you show an example of a calculated field, using one or more fields from the query? It seems like it’s only looking at the first record in the set and I can’t get it to work.

When I select the Id field, for example, I get query[0].Id:

image590×1012 39.6 KB

And, I only get the Id from the first record, repeated for every record in the query.