Tool in Mylly: Relation algebra / Part that does not match | fi

Part that does not match another relation

The ”miss” operation takes two relations and produces those records of the first that do not match the shared attributes of any record of the second.

The input and output relations are represented as TSV files.


The first input relation consists of some word forms annotated with a lemma, a sentence number, and a token number. The second input relation consists of sentence numbers annotated with the mood of a sentence.

sen tok lemma word
3 3 niin niin
3 2 se se
3 1 olla on
5 1 olla on
sen mood
3 calm
4 calm
5 angry

The output relation consists of those records of the first input relation that did not have their sentence number in any record of the second input relation (none of them).

tok sen lemma word

On the other hand, reversing the roles of the input relations produces those records of the second relation (the one that annotates sentence numbers with moods) that have no corresponding token in the first relation (sentence 4).

sen mood
4 calm

Related tools

See also

Search the Language Bank Portal:
Emmi Lahti
Researcher of the Month: Emmi Lahti



The Language Bank's technical support:
kielipankki (at)
tel. +358 9 4572001

Requests related to language resources:
fin-clarin (at)
tel. +358 29 4140599 / +358 29 4129317