Week number from day number

Options
BlueRabit
BlueRabit Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 11 ✭✭✭

We consider that we have a table that contains a column "Day".

In this table we have values like "21", "10", "16", .... anyvalue that could correspond to a regular day number from a date.

Starting from this, is there ay formula that could return me the week number of the year corresponding to this day number (for this actual month) ?

Thank you for your time,
BlueRabbit

Tagged:

Answers

  • tgb417
    tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,595 Neuron
    Options

    @BlueRabit

    I think I understand what you are getting at.

    In a visual recipe in a couple of steps, you could change the numbers into a parsed date. With the Parsed Date Step type. Then from the parsed date, there is a step that will provide date parts.

    If this is not to your point, please share a bit more detail. It is often to share a few example record and the output you expect to get.

  • Monica1
    Monica1 Dataiku DSS Core Designer, Registered Posts: 1
    Options

    How do I get the week number out of the date, as in the 1st week of January of any year should be "1", the second week "2" and so on till 52 weeks

  • tgb417
    tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,595 Neuron
    Options
Setup Info
    Tags
      Help me…