I am beginner in dataminer,
I have a list of 10000 rows and about 200 column like this :
look,1,2,3,4,5,6,7,8
book,4,5,6,7,8,102,104,107
look,6,7,8,9
hook,100,101,102
cook,7,8,9
build,102,103,104,107
hook,103,104,105
...
at first i need to make unique list of words:
look,1,2,3,4,5,6,7,8,9
book,4,5,6,7,8,102,104,107
hook,100,101,102,103,104,105
cook,7,8,9
build,102,103,104,107
Now I need to find lines with at least 3 (or n) similar values and generate a new list:
look,1,2,3,4,5,6,7,8,9
book,4,5,6,7,8,102,104,107
cook,7,8,9
*************
book,4,5,6,7,8,102,104,107
build,102,103,104,107
*************
hook,100,101,102,103,104,105
build,102,103,104,107
*************
Please help me in anyway
thank you