Select Only Value(String1) = Value(String2)

[Fanch]

Hi everybody,

I have a table box with many informations from different tables.

To simplify 🙂 :

my table1 contains the fields SERVER and ACCOUNT

my table2 contains the fields SERVER and LOGIN

When i make my table box, i have the next table 

But i only want when Value(ACCOUNT) = Value(LOGIN) as below

Thanks for yours answers !

[sunny_talwar]

You can create this in a straight table may be

Dimensions
SERVER
LOGIN

Expression

If(ACCOUNT = LOGIN, ACCOUNT)

[rubenmarin]

Hi, you can't set expression in a table box, try with a simple table chart. Server and account as dimension and one expression:

If(LOGIN=ACCOUNT, LOGIN)

[sunny_talwar · Accepted solution]

Hi Ruben

I think because an Account seem to have multiple LOGIN, this won't work with just Account and Server as dimension... Server and Login works though

[rubenmarin]

Hi Sunny, it has been a while since last chat. 

You are right, as usual. 🙂

[Fanch]

Hi,

you are too strong !! 💪

Greats, Thanks