From month and and Week no form a date

sgnarkhede2016sgnarkhede2016 Member Posts: 149 Contributor II
Hello,

Want to derive the date from Month and Week no.

e.g.
Month Feb
Week no 2 
So from any date from 2nd week like 9Feb2023

Answers

  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 881 Unicorn
    Hi!

    The easiest way to do this is getting a list of dates for the possible date range, extract the required attributes from the date, and join on your data. 

    List of dates: Generate Data, Generate ID, Generate Attributes with date_add()

    Extract the required attributes: Generate Attributes or possibly Date to Nominal or Date to Numerical, depending on the format of existing data.

    Regards,
    Balázs
Sign In or Register to comment.