Challenge
https://ampscript30.com/ampscript-challenge-day12/
To display customers’ transaction and loyalty details on the email.
Solution
%%[
SET @fullname = Concat(FirstName, " ", LastName)
SET @email = Email
SET @rows = LookupRows("AMPscript - Day 12 Rental_Transactions", "Email", @email)
SET @rowscount = RowCount(@rows)
SET @remaining = Subtract(10, @rowscount)
IF @rowscount >= 10 THEN
SET @msg = "you have earned 100 points!"
Else
SET @msg = Concat("you are ", @remaining, " rent(s) away to earn 100 points")
ENDIF
]%%
Hello %%=v(@fullname)=%%,
Congratulations on renting from our car rental services! You have rented a total of %%=v(@rowscount)=%% time(s) and %%=v(@msg)=%%.
Preview
Summary
Use LookupRows(name of data extension from which to return specified rows, column name used to identify rows to return, value used to match rows to return) to look up rows in another Data Extension based on the matched values. Use RowCount(specified rowset) to calculate the total count of all the rowset.