Do we have any specific syntax to look at specific DE for the field if it's empty or not empty?
%%[IF NOT EMPTY (@PRODUCT_CODE)IN [Data Extension] THEN]%%
I want to look only at specific DE as I'm traversing through 3 Different DE and this field has a value that is present in 2nd DE but not in 3rd DE and based on this Dynamic Content is getting populated.
Do reply if someone knows this!
<!--BEGIN CONTENT_REGION_|Check Reorder|--> %%[ var @CUSTOMER_ID, @rows1, @row1, @rowCount1, @i SET @CUSTOMER_ID = AttributeValue("CUSTOMER_ID") SET @rows1 = LookupRows("DE2","CUSTOMER_ID", @CUSTOMER_ID) SET @rowCount1 = rowcount(@rows1) IF @rowCount1 > 0 then FOR @i = 1 to @rowCount1 do Var @PRODUCT_CODE SET @row1 = row(@rows1, @i) /* get row based on counter */ SET @PRODUCT_CODE = field(@row1,"PRODUCT_CODE") IF NOT EMPTY(@CUSTOMER_ID)THEN VAR @rows2, @row2, @rowCount2, @j SET @rows2 = LookupRows("DE3","PRODUCT_CODE", @PRODUCT_CODE) SET @rowCount2 = rowcount(@rows2) IF @rowCount2 > 0 then FOR @j = 1 to @rowCount2 do var @NAME1, @NAME2, @IMAGE, @LINK, @COPYRIGHT2 SET @row2 = row(@rows2, @j) /* get row based on counter */ SET @NAME1 = field(@row2,"NAME1") SET @NAME2 = field(@row2,"NAME2") SET @IMAGE = field(@row2,"IMAGE") Set @link = Concat('https://', @IMAGE) SET @LINK = Concat('https://',field(@row2,"LINK")) SET @COPYRIGHT2 = field(@row2,"COPYRIGHT2") next @j ENDIF ENDIF next @i ENDIF ]%% %%[IF NOT EMPTY (@PRODUCT_CODE)THEN]%% <HTML - Dynamic Content Block>