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.

How to check for even numbers?

Hi,

I want to read only even numbers in a column?

Please let me know the formula.

Regards,
Praveen

Answers

  • AkshayAkshay Posts: 110 admin
    edited March 12, 2020 10:12PM
    Hello Praveen,

    Please use the following compute statement to check whether the values in your column are even/odd. if(find(".",STR(@[email protected]/2)) >0,"odd","even")

    Once you perform this compute, you could use the remove rows function to get rid of the odd values.

    I hope this helps.

    Thank You and Best Regards,
    Akshay
Sign In or Register to comment.