Select specific values from one field

[KyriakosM]

Hi everyone,

Do you know how can i get values from Field 1 that does not contain 0 value in Field 2.
For example I would like to select only "BBB" and "DDD" from the table below: (red color)

Field 1	Field 2
AAA	1
AAA	2
AAA	0
BBB	1
BBB	2
CCC	0
CCC	2
DDD	3

[Pierrick]

Hello,

Do you want to do this in the script, in the visualization (set analysis) or in a selection filter ?

[Ahidhar]

in script you can use 

where Field 2<> '0';

and in Front End 

if(Field 2<>'0',Field 2)