Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Kumar6
Contributor
Contributor

How to fetch a get a data for this scenario

Hello all,

I am facing problem in deriving the solution for below problem

Load 

dt_diff, sequence

5  , 1

45, 2

90, 3

180, 4

270, 5

I wanted a solution like this  below

dt_diff, sequence

5  , 0

45, 1

90, 2

180, 3

270, 4

Anything  less than dt_diff  45 should come under the sequence 0, then it should populate sequentially

hope my question is clear

any inputs appreciated

 

 

Labels (3)
1 Reply
Taoufiq_Zarra

@Kumar6  just to understand what is the expected output from this :

dt_diff, sequence

5 , 1

45, 2

90, 3

4,4

180, 5

270, 6

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉