Remove columns by pattern

Solved!
nshapir2
Level 1
Remove columns by pattern

Lets say I want to remove all the columns that contain the word "Spot" in them. How would I do that. I cannot figure out the syntax for Remove columns matching. 

0 Kudos
1 Solution
AlexT
Dataiker
Dataiker

Hi,

You could do this using a Visual Prepare recipe and adding a step with the processor library "Delete/Keep Columns by name". 

https://doc.dataiku.com/dss/latest/preparation/processors/columns-select.html#delete-keep-columns-by...

Within that you can use regex to match on the pattern you are looking for example: .*Spot.*

 

View solution in original post

0 Kudos
2 Replies
AlexT
Dataiker
Dataiker

Hi,

You could do this using a Visual Prepare recipe and adding a step with the processor library "Delete/Keep Columns by name". 

https://doc.dataiku.com/dss/latest/preparation/processors/columns-select.html#delete-keep-columns-by...

Within that you can use regex to match on the pattern you are looking for example: .*Spot.*

 

View solution in original post

0 Kudos
nshapir2
Level 1
Author

Thank you for your help!

0 Kudos
A banner prompting to get Dataiku DSS
Public