I'll get right into it. - I am trying to do the following:
I have two DEs one is my send DE, the other is a lookup table.
Let's say both data extensions have a column called [STATE].
The send DE has IL, WA, FL, GA, MN
The lookup DE has IL, WA, FL
I want to compare the two attribute values so if the states don't match or if there is a state in the send DE that isn't in the lookup DE it will show something else.
Some example code below:
%%[ VAR @State1, @State2 SET @State1 = [STATE1] SET @State2 = Lookup("StateLookupTable", "CITY2", "STATE2", @State1) IF AttributeValue["STATE1"] != AttributeValue["STATE2"] THEN (Show this) ELSE (Show this) ENDIF ]%%
All help is greatly appreciated!