Hi
the below rule
col0="orange"
and col1="apple"
and col2 ="fruits"
output
====
shopname, col0, col1, col2
xxxx,orange, apple, fruits
xxxx,orange, apple, fruits
yyyy,orange, apple, fruits
yyyy,orange, apple, fruits
yyyy,orange, apple, fruits
produces a list of all the records matches the condition, but the output result contains a lot of duplicates on a particular column ( for example column name "shopname" ), if i want to produce a row count of only the unique records from column "shopname" satisfying the above rule,
anyway to do that in IA
select count(distinct shopname)
from table1
where col0="orange"
and col1="apple"
and col3="fruits"
cheers
Mj
filtering "distinct" values count from the output
-
- Premium Member
- Posts: 139
- Joined: Fri Apr 11, 2008 1:02 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne