1 2 Previous Next 21 Replies Latest reply on Jan 17, 2017 8:27 PM by Shinichiro Murakami Go to original post
• ###### 15. Re: Action Filter and Network Connections

Is either of below correct?

[Vertex ID2 Lookup]

[Vertex ID 2]=[Vertex Union]

or if some table calc doe not work.

[Vertex ID2 Lookup (copy)]

lookup(min([Vertex ID 2]),0)=lookup(min([Vertex Union]),0)

might be alternative.

Thanks,

Shin

1 of 1 people found this helpful
• ###### 16. Re: Action Filter and Network Connections

Thank you very much, Shin san.

It worked!

I am not familiar with

[Vertex ID2 Lookup (copy)]

lookup(min([Vertex ID 2]),0)=lookup(min([Vertex Union]),0).

Is that comparing the minimum value of vertex ID2 and the minimum value of vertex union?  lookup(min(),0) <-- 0 means false? Then that's correct that min([Vertex ID 2]) is not equal to min([Vertex Union]), therefore, this statement is true?

Thank you,

Kazumi

• ###### 17. Re: Action Filter and Network Connections

Kazumi,

You can refer this .

Thanks,

Shn

1 of 1 people found this helpful
• ###### 18. Re: Action Filter and Network Connections

Hi Shin san,

Thank you for the reference.

I have another question if you have a chance. I am trying to show multiple vertex union connections.  For example, I selected vertex union 384 and 464.

I would like to show three selections using calculated filter:

1. show only connected to 384

2. show only connected to 464

3. show connected to both 384 and 464

For example, Vertex ID 703 is connected to both Vertex Union 384 and 464.  Vertex ID 2071 is only connected to Vertex Union 464.

I tried following formula to show Vertex IDs that are connected to both Vertex Unions, but it didn't work.

IF COUNTD([Vertex ID 1])>=2 then 'connected to both' END

Thank you for your kind help.

Sincerely,

Kazumi

• ###### 19. Re: Action Filter and Network Connections

Kazumi,

I'm so sorry, but I'm not comfortable to keep this thread to have additional question one after another.

Could you try something by yourself and post another thread with clear problem statement.

Thanks,

Shin

• ###### 20. Re: Action Filter and Network Connections

Hi Shin san,

I am sorry.  I agree that I shouldn't have asked additional questions to the same thread.  I will try to solve it by myself again.  If I still cannot figure it out, I will post it to a new thread with a better problem statement.

Sincerely,

Kazumi

• ###### 21. Re: Action Filter and Network Connections

Thank you for the understanding.

Too have many question and making a thread longer makes it difficult for other community members to learn from it.

That's another concern.

Thanks,

Shin

1 2 Previous Next