Forum Discussion

hgorina's avatar
hgorina
Frequent Visitor
7 years ago

fuzzy grouping

I am trying to group text based on fuzzy matching my initial approach was to group based on full match, but I have realised that this gigantic dataset is not consistent  
Need Help
hgorina's avatar
hgorina
Frequent Visitor
7 years ago

sample fuzzy matches
Thanks for responding
the dataset is huge, and it comes from the zipped log files from some software chashes, I cannot do anything with sql query and i think DAX will be way too slow. I am trying to work on the query level.

the goal is to find similar lines - they may have various numbers and verbalization, but they explain a reason for the crash, which I want to quantify

thanks again

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    HI hgorina,

     

    I think you need to create a calculated column to extract and store particular error message text.

     

    Then you can create a dictionary table with some keywords which used to compare with extracted error message text and as group category label.


    If you still confused on coding formula, can you please share some sample data with same data structure so that we can test to coding formula?

    Notice: please do mask on sensitive data before share.

     

    Regards,

    Xiaoxin Sheng