Home Data Prep Q&A


Big News: we’ve moved to the DataRobot Community! Please keep your eye out for an email invitation to join us there. Refer to the We've Moved FAQ for a guide on how to use your existing Paxata Community account to login to our new home.

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: 111 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.