Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Checking if the minimum at two different times is on the same day

Dennis229
7 - Meteor

Hey there. I want to see if the day with minimum degrees (at daytime), is the same day with minimum degrees (at night)

So basically the day with minimum degrees at morning, is it the same day with minimum degrees at night?

 

4 REPLIES 4
ShankerV
17 - Castor

Hi @Dennis229 

 

Please find the expected output.

 

ShankerV_0-1673517158144.png

 

Feel free to mark the solution of the post which helped to resolve the issue, so similar issues faced by other community members in future can be helpful to refer the solution.

 

Many thanks

Shanker V

 

 

ShankerV
17 - Castor

Hi @Dennis229 

 

Step 1: Input

ShankerV_0-1673517263038.png

 

Step 2: 

ShankerV_1-1673517282286.pngShankerV_2-1673517295803.png

 

Step 3: 

ShankerV_3-1673517318484.png

ShankerV_4-1673517327511.png

 

Feel free to mark the solution of the post which helped to resolve the issue, so similar issues faced by other community members in future can be helpful to refer the solution.

 

Many thanks

Shanker V

 

 

 

ShankerV
17 - Castor

Hi @Dennis229 

 

Step 4:

 

ShankerV_0-1673517371864.png

ShankerV_1-1673517393149.png

 

Step 5:

ShankerV_2-1673517407887.pngShankerV_3-1673517416088.png

 

 

step 6:

ShankerV_4-1673517434609.png

 

ShankerV_5-1673517450590.png

 

Feel free to mark the solution of the post which helped to resolve the issue, so similar issues faced by other community members in future can be helpful to refer the solution.

 

Many thanks

Shanker V

 

 

ShankerV
17 - Castor

Hi @Dennis229 

 

Step 7: Formula tool

ShankerV_0-1673517518218.png

 

IF [Day time Min_degree]=[Night time Min_degree]
then "Yes"
Else "No"
endif

 

ShankerV_1-1673517528547.png

 

Step 8: Just for sorting the date's

 

ShankerV_2-1673517585883.png

 

ShankerV_3-1673517596249.png

 

 

Expected Output:

 

ShankerV_4-1673517625203.png

 

Feel free to mark the solution of the post which helped to resolve the issue, so similar issues faced by other community members in future can be helpful to refer the solution.

 

Many thanks

Shanker V

 

 

Labels
Top Solution Authors