"Finding a relation between two attributes of a database"

duygu
duygu New Altair Community Member
edited November 2024 in Community Q&A
Hi everyone,

my 'learning process' continues! I have a database with 2 columns. One of them contains diagnosis of some diseases. The other one contains treatment for these diseases.
Now the thing that i wan to do is to find a relation between these 2 columns. For example; diagnosis is "fever" and treatment for this diagnosis is "take a cold shower". Another; diagnosis is "fever" again but this time treatment is "pill". And goes on like this.

Like in the association examples can I find a relation like "fever->pill" ?

Can we say that "WHEN THERE IS FEVER IN DIAGNOSIS WE MOSTLY SEE PILL AS A TREATMENT".


I hope i can explain  :D
Duygu.

Answers

  • bkriever
    bkriever New Altair Community Member
    If you are just looking for the most used treatment use the aggregate operator.  For 'Group by Attributes' select Diagnosis' and for 'Aggregation Attributes' select Treatment with the aggregation function set to Mode.