I have the following DE called Metering_ElecDE_email
Where there is a match with Email (in this case 1)i want the Email to display as per below.
Supply address: Hamilton (next line) ICP: ert (next line) Customer number: 321 (next line)
Supply address: Auckland (next line) ICP: ert (next line) Customer number: 432
I have the below which (i know) is wrong. Any help here is appreciated.
%%[ var @rows, @row, @rowcount, @i, @ICP, @supply_address, @customer_number, @Emailaddress,
set @rows = lookupRows ("Metering_ElecDE_email", "subscriber_key",_subscriberkey” )
set @rowcount = rowcount(@rows)
if @rowcount > 0 then
for @i = 1 to @rowcount do
set @row = row(@rows, @i) /*get row based on loop counter */
set @ICP = field(@row,"ICP")
set @site_address = field(@row,"supply_address")
set @party_code = field(@row,"customer_number")
]%%
ICP: %%=v(@icp)=%%
Supply address: %%=v(@supply_address)=%%
Customer number: %%=v(@customer_number)=%%
%%[next @i]%%
%%[endif]%%
I am not getting the desired output. Sorry am not a coder.