Browse
Discussions
Paxata Data Prep
Data Prep Q&A
Paxata Fundamentals
Admin Corner
Excel Transition Guide
Advanced Paxata Techniques
Product Release Notes
Platform
AI Platform Trial
Learning Sessions
Sessions
Knowledge Base
Resources
Blog
Eureqa Academic
About Community
Community News
Community Resources
English
English
日本語
Sign In
Sign Up
All Community
This category
This board
Knowledge base
Users
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Join TODAY's webinar—The Intelligence Revolution: Driving ROI with AI
Community
:
Discussions
:
Paxata Data Prep
:
Data Prep Q&A
:
How to create Age range in compute field??
Options
Subscribe to RSS Feed
Mark Topic as New
Mark Topic as Read
Float this Topic for Current User
Bookmark
Subscribe
Mute
Printer Friendly Page
How to create Age range in compute field??
H369199
NiCd Battery
Mark as New
Bookmark
Subscribe
Mute
Subscribe to RSS Feed
Permalink
Printer Friendly Page
Email to a Friend
Report Inappropriate Content
03-18-2020
08:37 PM
Hi,
I want to create a calculated field which can show the age group :
If Age<=19 THEN "14-19"
ELSEIF
Age>=20 and Age<=29
THEN "20-29"
ELSEIF
Age>=30 and Age<=39
THEN "30-39"
ELSEIF
Age>=40 and Age<=49
THEN "40-49"
ELSE
"50+"
END
can you please help me, how to write this in Paxata??
Regards,
Praveen
Labels
(1)
Labels
Labels:
Data Prep
0
Kudos
Share
Reply
All forum topics
Previous Topic
Next Topic
1 Reply
Akshay1
DC Motor
Mark as New
Bookmark
Subscribe
Mute
Subscribe to RSS Feed
Permalink
Printer Friendly Page
Email to a Friend
Report Inappropriate Content
03-18-2020
10:05 PM
Hello Praveen,
Could you please try the following compute statement to check if this works for you?
if(@Age@<=19,"14-19", if(@Age@<=29,"20-29",if(@Age@ <=39,"30-39",if(@Age@<=49,"40-49","50+"))))
Thanks,
Akshay
0
Kudos
Share
Reply
Labels
Advanced
1
Best Practices
3
Data Prep
119
Getting Started
4