Deliminator question

user17014
user17014 Member
in Magic ETL

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

 

 

 

Comments

  • NewsomSolutions
    NewsomSolutions Domo Employee

    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
    user17014 Member

    Thanks for the help

Categories