Revisions to Using AmpScript to populate email from Data Extension

source formatting, pretty up link

Source Link

edited Nov 20, 2017 at 14:07

31.1k
6
44
88

You are performing too many lookup queries. Please try the following code

SET @rows = LookupRows("Pull-Field-Test","Date", @today)

    IF RowCount(@rows) > 0 THEN

        SET @row = Row(@rows,1)

        SET @p1 = Field(@row,"Product-1")
        SET @p2 = Field(@row,"Product-2")
        SET @p3 = Field(@row,"Product-3")
        SET @p4 = Field(@row,"Product-4")
        SET @p5 = Field(@row,"Product-5")
    
    ENDIF

Note I have not tested this code, please look AMPScript documentataion

refer to https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-content.meta/mc-programmatic-content/lookuprows.htmthe LookupRows() AMPScript documentation

Kind Regards.

You are performing too many lookup queries. Please try the following code

SET @rows = LookupRows("Pull-Field-Test","Date", @today)

    IF RowCount(@rows) > 0 THEN

        SET @row = Row(@rows,1)

        SET @p1 = Field(@row,"Product-1")
        SET @p2 = Field(@row,"Product-2")
        SET @p3 = Field(@row,"Product-3")
        SET @p4 = Field(@row,"Product-4")
        SET @p5 = Field(@row,"Product-5")
    
    ENDIF

Note I have not tested this code, please look AMPScript documentataion

https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-content.meta/mc-programmatic-content/lookuprows.htm

Kind Regards

You are performing too many lookup queries. Please try the following code

SET @rows = LookupRows("Pull-Field-Test","Date", @today)

IF RowCount(@rows) > 0 THEN

    SET @row = Row(@rows,1)

    SET @p1 = Field(@row,"Product-1")
    SET @p2 = Field(@row,"Product-2")
    SET @p3 = Field(@row,"Product-3")
    SET @p4 = Field(@row,"Product-4")
    SET @p5 = Field(@row,"Product-5")

ENDIF

Note I have not tested this code, please refer to the LookupRows() AMPScript documentation.

deleted 5 characters in body

Source Link

edited Nov 20, 2017 at 11:02

Fayyaz A Mian

350
4
19

You are performing too many lookup queries. Please try the following code

SET @rows = LookupRows("Pull-Field-Test","Date", @today)

    IF RowCount(@rows) > 0 THEN

        SET @row = Row(@rows,1)

        SET @p1 = =FieldField(@row,"Product-1")
        SET @p2 = =FieldField(@row,"Product-2")
        SET @p3 = =FieldField(@row,"Product-3")
        SET @p4 = =FieldField(@row,"Product-4")
        SET @p5 = =FieldField(@row,"Product-5")
    
    ENDIF

Note I have not tested this code, please look AMPScript documentataion

https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-content.meta/mc-programmatic-content/lookuprows.htm

Kind Regards

You are performing too many lookup queries. Please try the following code

SET @rows = LookupRows("Pull-Field-Test","Date", @today)

    IF RowCount(@rows) > 0 THEN

        SET @row = Row(@rows,1)

        SET @p1 = =Field(@row,"Product-1")
        SET @p2 = =Field(@row,"Product-2")
        SET @p3 = =Field(@row,"Product-3")
        SET @p4 = =Field(@row,"Product-4")
        SET @p5 = =Field(@row,"Product-5")
    
    ENDIF

Note I have not tested this code, please look AMPScript documentataion

https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-content.meta/mc-programmatic-content/lookuprows.htm

Kind Regards

You are performing too many lookup queries. Please try the following code

SET @rows = LookupRows("Pull-Field-Test","Date", @today)

    IF RowCount(@rows) > 0 THEN

        SET @row = Row(@rows,1)

        SET @p1 = Field(@row,"Product-1")
        SET @p2 = Field(@row,"Product-2")
        SET @p3 = Field(@row,"Product-3")
        SET @p4 = Field(@row,"Product-4")
        SET @p5 = Field(@row,"Product-5")
    
    ENDIF

Note I have not tested this code, please look AMPScript documentataion

https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-content.meta/mc-programmatic-content/lookuprows.htm

Kind Regards

Source Link

created Nov 19, 2017 at 23:39

Fayyaz A Mian

350
4
19

You are performing too many lookup queries. Please try the following code

SET @rows = LookupRows("Pull-Field-Test","Date", @today)

    IF RowCount(@rows) > 0 THEN

        SET @row = Row(@rows,1)

        SET @p1 = =Field(@row,"Product-1")
        SET @p2 = =Field(@row,"Product-2")
        SET @p3 = =Field(@row,"Product-3")
        SET @p4 = =Field(@row,"Product-4")
        SET @p5 = =Field(@row,"Product-5")
    
    ENDIF

Note I have not tested this code, please look AMPScript documentataion

https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-content.meta/mc-programmatic-content/lookuprows.htm

Kind Regards

Stack Exchange Network

Return to Answer