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?