Personalization Token for Supplementar Tables
Hi there,
I'm having some trouble on create an SMS campaign that has a personalization token of a supplementar table's column.
Basically we have two tables: Our CONTACT_LIST, which CUSTOMER_ID_ is the PK and links to the column NUMBER_ACCOUNT of TRANSACTION_SUP table, which have another PK for each transaction that's NUMBER_TRANSACTION. The Extraction Keys are both NUMBER_ACCOUNT and NUMBER_TRANSACTION.
In our campaign we need to message the customers with their FIRST_NAME on CONTACT_LIST and with the VALUE_WITHDRAW of TRANSACTION_SUP.
I set the personalization token on Message Desinger and set on Data Source CUSTOMER_ID_ and NUMBER_ACCOUNT as lookup key, but the campaign show up an error message:
0