Coupon codes mapping

[sah_]

HI Community,

I have a csv file that contains unique coupon codes, within a campaign I have to assign a unique code as per the customer.

can anyone please let me know how can I achieve it using enrichment

[Rch_]

Hi @sah_,

When you load the CSV using the Data Loading (file) activity, just skip selecting a schema — Campaign will automatically create a temporary table for you behind the scenes. This is great if you don’t need to store the coupons long-term or reference them later.

Here’s how you can handle the unique assignment using enrichment:

1. Load the CSV file with coupon codes (as a temporary table).
2. Add a Row Number in the enrichment step to both:

- Your recipient data
- The loaded coupon data

*Use this RowNum() function*

3. Join the two datasets using the row number (1st row to 1st row, 2nd to 2nd, etc.)

This way, each customer gets exactly one coupon — no custom schema needed.

Thanks,

[sah_]

Hi @Rch_ 

Thank you for your response

Can you please attach some snaps of point 3

[Rch_]

Hi @sah_,

For 3rd point it will be like creating a link between those row number. Attaching snip as well:

Thanks,