I have set up following activities in Automation Studio:
See below for Order: 1. File Drop 2. Import the data into a data extension 3. Import Mobile Contacts Activity 4. Automation SMS Send activity - In this outbound template I am using the following ampscript: Your amount is %%=Lookup("DENAME","Column","MobileNumber",MOBILE_NUMBER,"Sent","N")=%%. %%=UpdateData("DENAME",1, "MobileNumber", MOBILE_NUMBER, "Sent","Y")=%%
The SMS is received on my device but it also has a number along with it. For example the message say - Your amount is $10.00 and there is 1 beside it. If I run the automation again by dropping a new file with same mobile number in the file, the message reads - Your amount is $11.00 2.
Can somebody suggest if I am doing something wrong.