Deliminator question

user17014

I want to count the information but don't want duplicates how can I do this and add the correct info for an accurate count?

 

AHA.10133|1

AHA.101361799|1

AHA.10205|1

AHA.1012178447|1

AHA.10135|1

AHA.10135|3

AHA.10138|7

AHA.103352686|1

AHA.103352686|1

AHA.103352686|1

 

AHA.10135|1

AHA.10135|3

AHA.10138|7

Want this to equal 1

 

AHA.103352686|1

AHA.103352686|1

AHA.103352686|1

want this to equal 1

 

Thanks,

Josh

 

 

 

NewsomSolutions

If this data is broken up in two columns already you can use this:

To count without duplicates: count(distinct())

You can do this from beastmode in a card or do if from mysql. 

 

If you are trying to ignore the bar and whatever number is after it, then you'll have to do some more work of course:

*If you're already in the card and you want to work from a beast mode then you can run

count(distinct(SUBSTRING(`FIELD NAME`, 1, instr(`FIELD NAME`,'|')+1)))