Finding or lookup a value from another row

[craz123]

Hi guys,

I'm trying to figure this out, what i have:

sessionid | name | sequence

123 | abc | 1
123 | abe | 2
123 | abd | 3
124 | abe | 1
124 | abd | 2
125 | abe | 1
125 | abc | 2

Target state:

entryname | targetname | distinct count of occurrence per session
abe | abd | 2
abe | abc | 1

Appreciate the help - trying to do this in a Qliksense Expression (not script)

[G3S]

are these fields available in a different table in the script? 
entryname | targetname 

or are you wanting to derive them from the data table?