I have a data extension with multiple fields and would like to group the output based on the specific field.
For example the fields on the DE are:
- Product Type
- Interest Rate
I would like to group the data outputs based on the product type (rather than repeat the Product Type for each output, for example:
Product Type A
- Interest Rate 1, Amount 1
- Interest Rate 2, Amount 2
- Interest Rate 3, Amount 3
Product Type B
- Interest Rate 4 Amount 4
I have built the code to output the data without grouping (see below), but not sure how to modify this to achieve what I need.
%%[ SET @GroupRows = LookupRows("Product Data Extension", "Reference ID",[Reference ID]) FOR @counter=1 TO RowCount(@GroupRows) DO SET @currentRow=Row(@GroupRows,@counter) SET @Amount=Field(@currentRow, "Amount") SET @Rate=Field(@currentRow, "Rate") SET @ProductType=Field(@currentRow, "Product Type") ]%% /* display output fields */ %%[ NEXT @counter ]%%
Any suggestions would be great. Thanks!