Populate an email with data outside of the database

Hi there,

Query here for Adobe Campaign Classic:

Here's a scenario i'm trying to find a workaround for.

We have a marketing email that we want to send and we need to populate with a unique discount code for each recipient.

We have the codes in a .csv file and the email addresses to target, but how do i populate the creative with data field outside of the database?

We could upload and target a list of email addresses and codes and populate this way, however, the send needs to be linked to the recipient database, to capture potential unsubscriptions and engagement etc.

Ideal scenario would be to match the emails on the .csv file Vs the recipient database and then enrich the discount code from the .csv file.

Is this possible? (tried and failed using the edit schema tool)

Thanks in advance,

Andy