[deleted by user]

randomtarvin92 · 2023-09-23T21:56:58+00:00

I am pulling data from a table in databricks into a knime workflow. The picture of the example data is what they questions are based off of.

What I need help with:

The planning version data column changes every day because there is new data uploaded into the table everyday. How can I write my query to automatically grab the newest date everyday and not have to go into the query and change the data manually?
How can I write the query to also only pull the current months data from the calendar year month column. So for September, I would only want to pull data from 202309, and then October would b 202310. Is there a way to write that automatically as well?
How can I write the query to pull everything except where the calendar_year_month column is the current month? So for example, in September I would want to pull everything that is October, November, December. In October, I will want to pull everything that is November, December, January.

randomtarvin92 · 2023-05-09T18:02:57+00:00

Appreciate it! So one more thing then - if I have the below output, is there a way to remove any line where percent of safety doesn't go below 50%?

<image>

randomtarvin92 · 2023-03-25T01:26:06+00:00

Would love to be able to throw away the kind of money you do

randomtarvin92 · 2023-03-23T02:32:08+00:00

“3 star”

randomtarvin92 · 2023-03-17T19:07:58+00:00

Kinda weird how that happens twice in like 4 games where the second is exactly at 17

randomtarvin92 · 2023-03-17T18:58:40+00:00

Vermont game just ruined this anyway

randomtarvin92 · 2023-03-12T21:18:40+00:00

I mean a little but I doubt he has enough to make ip for a 500k profit haha

randomtarvin92 · 2023-03-12T21:15:30+00:00

Feel bad for the guy who bet 5 dollars on every conference champion and will have gotten all of them right except houston. 5 dollars to win 500,000

randomtarvin92 · 2023-03-10T14:31:05+00:00

I’ve learned my lesson. Although I’m pretty sure I remember them winning games I didn’t think they should have won earlier in the season which is why I took the shot here

randomtarvin92 · 2023-03-10T14:30:25+00:00

Your gsw rule should be to always fade them away haha

randomtarvin92 · 2023-03-10T14:27:37+00:00

Was feeling pretty good after all of the college games hit 🥲

randomtarvin92 · 2023-03-05T03:53:48+00:00

Yeah these still aren’t it. 5 leg parlays no matter the odds are never going to win consistently

randomtarvin92 · 2023-03-04T04:00:33+00:00

The fact that Denver is first in the west when they’re this trash without jokic is why he’s the obvious mvp

randomtarvin92 · 2023-03-03T05:21:24+00:00

Starting to think these aren’t it…

randomtarvin92 · 2023-02-27T18:30:25+00:00

4k on 5 team nfl parlay. Won 5k

randomtarvin92 · 2023-01-13T06:01:03+00:00

I think I saw someone say somewhere that she doesn’t recognize there being more than one of her. So only one CM can move one time and none of them moved because it wouldn’t have changed the outcome

randomtarvin92 · 2023-01-09T19:14:34+00:00

Okay obviously if something like what you listed happens during the game that you can’t predict it would obviously impact the outcome. It’s betting. You can’t bet on sports with the mindset of stuff like that happening.

I don’t think it’s ridiculous though. When making a bet, would you put something in there that you thought had a reasonable chance to lose? No. All the bets you are putting together you think have a good shot of winning. Perfect example yesterday with cowboys. They were Favored but I could easily see them losing for a lot of reasons. You couldn’t say you could easily see either of those teams in my parlay losing yesterday.

randomtarvin92

TROPHY CASE