We do extracts from FE into another system. Because we have vendors with multiple payment addresses. We need to be able to combine the Vendor ID field with the description field to make that a unique Vendor ID field. I am requesting the ability to combine/concatenate multiple fields inside query. I know this can be done in Excel but these are payment files and we don't want users to touch the file after extraction.
Thank you.