Simple Set analysis hellp

[#1]

I have a spreadsheet two two columns

Division and Helps as a column header.

So in the helps column there could be other divisions or Orgs, Sucjh as

Division   Helps

D1          D2

D3          D1

D1          Org1

I want to have a straight table that shows D1 what other divisions D1 helps without the Org1, so basically where Helps=another division name

[andrewpettit]

I personally would pre-calculate a flag on the backend that says if they are equal or not and then write my Set Analysis to select either a 1 or 0 in my flag field.

[preminqlik]

try this !

in UI : if(Helps<>'Org*',Helps)

or

in script:

while loading u can keeep flag as :

load Division,

          Helps,

          if(Helps<>'Org*',1,0)                    as               helps_flag

FROM..............

IN UI CALL AS ; IF(helps_flag=0,Helps)

[israrkhan]

you can also try like this,

if( Helps = 'D*',Helps)