Deliminator question

user17014 · July 2019

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.10135|1

AHA.10135|3

AHA.10138|7

Want this to equal 1

AHA.103352686|1

want this to equal 1

Thanks,

Josh

NewsomSolutions · July 2019

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)))

user17014 · July 2019

Thanks for the help

Magic ETL