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.