Expand my Community achievements bar.

Accelerate your Campaign learning with the Adobe Campaign Mentorship Program 2023!

Querying two variables against eachother


Level 2

Hello, I am trying to design a segmentation where I take the market of a user (for example de_de) and compare it to the ID of their individual entries in a second table (for example de_de_xx_xx).

I have noticed that this is not possible from graphical user interface, but even when trying to write advanced expressions I cannot get it to do what I want either by using LIKE/NOT LIKE or IN. For example using Upper(@questionID) NOT LIKE Upper(@market) I get all entries in the same flow, despite having different markets in the ID.

Is it not possible to do these kinds of lookups, or am I doing something wrong?

0 Replies