i have this kind of data in a data extension:

DesktopType1 (column-Name) Hard Drive 250 (column-Spec)

DesktopType1 (column-Name) RAM 4GB (column-Spec)

DesktopType1 (column-Name) 1080p (column-Spec)

DesktopType2 (column-Name) Hard Drive 150 (column-Spec)

DesktopType2 (column-Name) Wifi (column-Spec)

Since i can have multiple rows for each product depending on the spec. Can i compare two or more products and display the difference in email body by ampscript?

  • 2
    Please update your question to include a sample of the desired output. Commented Aug 7, 2017 at 11:33
  • Could you also please add a bit more clarity around the content of the input? A screenshot might help.
    – Macca
    Commented Aug 7, 2017 at 12:00

1 Answer 1


Your values would need to be a number (i.e. 250 instead of Hard Drive 250GB, and 4 instead of RAM 4 GB, etc). You could use math functions after you LookupRows to make your comparisons.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .