chapter3.amp

%%[
    /* 
       Steps:
       1. Specify the Data Extension name, search attribute, and case-sensitive search value.
       2. Use LookupRowsCS to retrieve rows that match the criteria.
       3. Get the total number of matching rows.
       4. Loop through each row to extract and optionally display column values.
    */

    /* Declare variables */
    var @rows, @dataExtensionName, @attributeToSearch, @valueToSearch, @rowCount, @index, @row

    /* Set the name of the data extension to be used */
    set @dataExtensionName = "My_DataExtension"

    /* Set the attribute to search by in the data extension */
    set @attributeToSearch = {{attributeToSearch}}

    /* Set the value to search for in the given attribute */
    set @valueToSearch = {{valueToSearch}}

    /* Use the LookupRowsCS function to fetch all rows that match the search criteria */
    set @rows = LookupRowsCS(@dataExtensionName, @attributeToSearch, @valueToSearch)

    /* Get the total number of rows returned by the LookupRowsCS function */
    set @rowCount = RowCount(@rows)

    /* Check if any rows were returned */
    if @rowCount > 0 then
        /* Loop through each row and extract values for specified columns */
        for @index = 1 to @rowCount do
            set @row = Row(@rows, @index)

            {{columnAssignments}}  

            /* Optionally: you can output these values for debugging or further use */
            OutputLine(concat({{outputLineColumns}}))
        next @index
    endif
]%%