How to assign random code for recipient in delivery?

Avatar

Avatar
Validate 1
Level 2
malarrajans8868
Level 2

Likes

3 likes

Total Posts

15 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
malarrajans8868
Level 2

Likes

3 likes

Total Posts

15 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile
malarrajans8868
Level 2

07-09-2016

Hi All,

I have a table(coupon) contains with some coupon code only.But there is no mapping with any other table.

I need to assign the random coupon code based on the table(coupon) with recipient while sending delivery.

Is there anyway to do it.

Kindly help on this.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 2
malarrajans8868
Level 2

Likes

3 likes

Total Posts

15 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
malarrajans8868
Level 2

Likes

3 likes

Total Posts

15 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile
malarrajans8868
Level 2

08-12-2016

Hi Vipul Raghav

I have done without linking in schema level.

1.I have added one more column(line number) in coupon table.Which will be inserted while import the data.

2.I am able to assign the random number when querying the recipient.

3.After that linking the random number with the line number in coupon table using enrichment.It will assign the coupon code for the recipient.

Regards,

Malarrajan Sundarraj

Answers (4)

Answers (4)

Avatar

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Vapsy
Employee

13-10-2016

without link between two tables, it is not possible.

You will have to come up with a logic to identify a coupon code for each recipient of yours.

Avatar

Avatar
Validate 1
Level 2
malarrajans8868
Level 2

Likes

3 likes

Total Posts

15 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
malarrajans8868
Level 2

Likes

3 likes

Total Posts

15 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile
malarrajans8868
Level 2

27-09-2016

No. Each recipient will get unique coupon code.

Avatar

Avatar
Level 1
santiagos970632
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
santiagos970632
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
View profile
santiagos970632
Level 1

16-09-2016

Hola buenas tardes, desde Colombia. Yo logro personalizar ofertas, siempre que los destinatarios tenga su información ya cargada... es decir, se debe modificar o cargar los destinatarios con la información en el campo que necesitas que cambie para personalizar las ofertas...

Espero te sirva ayuda, saludos

Avatar

Avatar
Validate 1
Employee
Linda_Stinson
Employee

Likes

51 likes

Total Posts

250 posts

Correct reply

77 solutions
Top badges earned
Validate 1
Ignite 5
Ignite 3
Ignite 20
Ignite 10
View profile

Avatar
Validate 1
Employee
Linda_Stinson
Employee

Likes

51 likes

Total Posts

250 posts

Correct reply

77 solutions
Top badges earned
Validate 1
Ignite 5
Ignite 3
Ignite 20
Ignite 10
View profile
Linda_Stinson
Employee

09-09-2016

Will each Recipient get the same coupon code, or will they each get a different one? Is there any cross-reference with the Recipient such as zip code to determine who gets which coupon code?

Linda