Querying two variables against eachother

Richard_Bystrom

24-01-2019

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?

Accepted Solutions (0)

Answers (0)