Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Querying two variables against eachother

Richard_Bystrom
Level 2
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