I want to know if it's possible to get a new field from dbquery that does not exist in an index:
[|inputlookup file.csv | table field_ip]
| join type=outer fieldA [dbquery ..."select......" |fields + fieldA |rename fieldA as fieldB]
i tried this, but was not successful. fieldB doesn't exist in index=A, but i need it. How can i do it?
The right way to do this is a dblookup.
but the dblookup can return just the first matching line in my database