crmTech/ September 27, 2018/ Salesforce Marketing Cloud/ 0 comments

Most scenarios, it needs to be fetch the data from DE. You can achieve this using SSJS or AMPScript.

Find below AMPScript code snippet to retrieve the FirstName and LastName from TEST DE.

You can use this in Email or Cloudpage.

%%[
	 SET @rowset = LookupRows("TEST DE","FirstName",FirstName,"LastName",LastName)
	 SET @row = Row(@rowset, 1)
	 SET @FirstName = Field(@row, "FirstName")
	 SET @LastName = FIELD(@row, "LastName")
	 
	 if @FirstName == "XYZ" then
		output(v(@LastName))
	 else
		output(v(@FirstName))
	 Endif
 ]%%
Advertisements
Share this Post

About crmTech

Sharad is working from more than 11 years in IT industry. He has giving his technical services in CRM for telecom, automobile, retail, finance industry in Sales, Service and Marketing. He has primary skill in Siebel and Salesforce Marketing Cloud. Apart from this he has worked in Google Cloud, Wordpress blogging, SEO optimization, Short film making, mobile apps creation,logo design creation for his own interest.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.