Home Data Prep Q&A

Paxata Community Members: Something special in a community experience is coming your way. Stay tuned to this space.
In the meantime, check out the brand new Data Prep for Data Science topic here and the new DataRobot Community.

Visit the official Paxata Documentation portal for all of your doc needs.

Exculde rows in Dataset

Input : In below dataset we want to exclude HBT and SPS records for the year 2018 and 2019.

 

SBU

    Year

Amount

AERO

2017

1000

HBT

2017

500

SPS

2017

100

AERO

2018

1000

HBT

2018

500

SPS

2018

100

AERO

2019

1000

HBT

2019

500

SPS

2019

100

 

Output :

 

SBU

Date

Amount

AERO

2017

1000

HBT

2017

500

SPS

2017

100

AERO

2018

1000

AERO

2019

1000

 

Thanks for your help in advance

Answers

  • hi there, have you used the remove rows tool before? First you'll use a filtergram to filter on just those values in the column, then the remove rows tool will remove them. if this is not what you're after, please provide a little more context to your problem and we'll get you sorted.

  • @H369199
     
    I'm with @Melanie. I created a dataset using your data and used the Remove Rows tool as follows to get the desired change: 



Sign In or Register to comment.