"Finding a relation between two attributes of a database"

duygu
New Altair Community Member
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
Duygu.
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

Duygu.
0
Answers
-
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.0