Split my dataset from key column auto-recognition

shosho88

Hello, Bonjour,

I have a dataset and I want to spilt it in 2 parts. Data from a key column (2000 rows)

In this key column is a full sentence (exemple : "hello how r u", "how r you", "hello fine")

And when a key word is detected ("exemple : hello") it'll split automatically in one new dataset and when it's not detected it'll split in the second new dataset.

Hope my english isn't too bad :d

Thanks for your help! Cheers

AlexGo

No problem! You just need to change it to 'At least one of the following' in the drop down at the top, and then add additional conditions.

You could also use a regular expression or a formula if you're comfortable with those

AlexGo

Hi,

You should be able to use the 'Split' visual recipe for this. You just need to select the 'Define filters' and then use the column 'contains' condition. You can split to several different datasets based on terms, or add several conditions to each dataset if you want.

Everything else will go by default to the second dataset.

Jurre

<edit> reaction removed, @AlexGo
beated me with reaction time

shosho88

Thanks @AlexGo
it work perfectly!

I want to use different key words. I can use space between them or coma ? or something else ?

Thanks

shosho88

Thanks guys for the solutions