concat lookuprecords within a lookuprecords on a different data sheet
in Responsys
I have been doing this manually changing the lookuprecords field within a data sheet. I'm wondering if it is possible to do a lookup within a lookup?
e.g. I currently use:
<a href="$clickthrough(concat(lookuprecords(1_Bulletin, Bulletin_Content, EMAIL_DATE, lookup(DateReference), SEND_DATE),ARTICLE7), Position=1, concat(Term=,lookuprecords(1_Bulletin, Bulletin_Content, EMAIL_DATE, lookup(DateReference), ARTICLE7CATEGORY)), concat(Content=BodyImg,lookuprecords(1_Bulletin, Bulletin_Content, EMAIL_DATE, lookup(DateReference), ARTICLE7DESCRIPTION)))$" style="color:#248eb6; text-decoration:underline;" target="_blank" title="$lookuprecords(1_Bulletin, Bulletin_Content, EMAIL_DATE, lookup(DateReference), ARTICLE7DESCRIPTION)$">
I would like to make the number in the lookup field dynamic so instead it would say <a href="$clickthrough(concat(lookuprecords(1_Bulletin, Bulletin_Content, EMAIL_DATE, lookup(DateReference), SEND_DATE),ARTICLEX..
0