Hi HeinzWaescher,
see the docs about lookup
Note: The lookup command can accept multiple lookup and local fields and destfields. For example:
lookup <lookup-table-name> <lookup-field1> AS <local-field1>, <lookup-field2> AS <local-field2> OUTPUTNEW <lookup-destfield1> AS <local-destfield1>, <lookup-destfield2> AS <local-destfield2>
the only thing you must be aware of, is that the local-field
should exists if you use it in a lookup. That would be in your use case User and Country
.
hope this helps ...
cheers, MuS