0

Right now, I have this AMPscript that displays first name of the subscriber from the data extension since I am sending email to data extension as audience.

%%[
var @fname
set @fname = [First-Name]
]%%

Dear %%[IF not empty(@fname) THEN]%%%%=v(@fname)=%%%%[ELSE]%%Customer%%[ENDIF]%%

But, when I try to add more columns from the same data extension so that I can display value from address, title etc I get error in my AMPscript?

Can anyone please clarify if my ampscript is correct? if no, how can i correct it?

This is what I got so far:

%%[
var @fname, @decolumn_2, @decolumn_3
set @fname = [First-Name]
set @decolumn_2 = [DE-Column-2]
set @decolumn_3 = [DE-Column-3]
]%%

Dear %%[IF not empty(@fname) THEN]%%%%=v(@fname)=%%%%[ELSE]%%Customer%%[ENDIF]%%


Displaying other information below:

%%=v(@decolumn_2)=%% | %%=v(@decolumn_3)=%%
1

The issue could stem from if any of those columns are empty or null values. AMPscript can sometimes have issues with variables being set to null and throw errors.

To better handle null or empty values, I would recommend using the AttributeValue() function for setting your variables.

Example:

%%[

  VAR @fname, @decolumn_2, @decolumn_3

  SET @fname = AttributeValue("First-Name")
  SET @decolumn_2 = AttributeValue("DE-Column-2")
  SET @decolumn_3 = AttributeValue("DE-Column-3")

]%%

  Dear %%[IF not empty(@fname) THEN]%%%%=v(@fname)=%%%%[ELSE]%%Customer%%[ENDIF]%%


  Displaying other information below:

  %%=v(@decolumn_2)=%% | %%=v(@decolumn_3)=%%
  • Thank you. Is this another way to solve issue because this will handle NULL value too? OR attribute is a safer way to go about it? %%[IF not empty(@decolumn_2) THEN]%%%%=v(@decolumn_2)=%%%%[ELSE]%%DE_Default_Value%%[ENDIF]%% – kuml Jul 17 '17 at 12:53
  • It is the SETTING of the variable part that has issues with NULL, not the conditional statements. AttributeValue is usually best practice when setting variables as it is the most flexible. – Gortonington Jul 17 '17 at 12:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.