AnsweredAssumed Answered

word frequency?

Question asked by tonyberber on Mar 9, 2011
Latest reply on Mar 11, 2011 by tonyberber

Title

word frequency?

Post

I have a database in FM Pro 11 with two tables. The first one (named concordances) holds sentence fragments, in which each word is in a separate field. I use it to search for occurrences of particular words in field word06, for instance the word 'part':

Id 1

word01: for
word02: the
word03: first
word04: time
word05: as
word06: part
word07: of
word08: the
word09: school
word10: project
word11: that

Id 2
word01: and
word02: since
word03: it
word04: is
word05: all
word06: part
word07: of
word08: the
word09: same
word10: deal
word11: we

etc. up to record 771.

The second table (named corpus) has all the word frequencies in the whole database:

Id 1
word: the
frequency: 28373


Id 2
word: of
frequency: 24761

...

Id 39383
word: part
frequency: 771

etc. up to record 101576,

What I'd like to do is to calculate the joint frequencies of words in fields word01 through word06, and then match these with the frequencies already in table corpus. This would like something like this:


Id 1
word: the 
frequency in found set: 36
frequency in corpus: 28373

Id 2
word: of 
frequency in found set: 22
frequency in corpus: 24761

Thank you ahead for any pointers!

Outcomes