Coloumn contains specific words then return that word

gauravgarg
Level 2
Coloumn contains specific words then return that word

I have a dataset containing 30 keywords. I'm looking at those keywords in another column in another dataset. The keywords are written in between the text. I want to return that keyword in front of those cells. Any recipe for this?

0 Kudos
1 Reply
JordanB
Dataiker

Hi @gauravgarg,

It sounds like you might be able to use an "extract with regular expression", "split column" or "find and replace" processor within a Prepare recipe. However, we would need more details on your use case (how your data looks now and how you want your output data to look). Screenshots would be helpful. 

Thanks!

Jordan

0 Kudos