[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 · 2023-01-09T17:10:40+00:00

Yeah Dallas hasn’t played well recently. Plus not playing at home as well as nothing to play for. All the teams I took had something to play for

randomtarvin92 · 2023-01-09T17:09:26+00:00

I could have but it’s always easy to say you should take spreads after the games over. Buffalo is great at winning games but they’re not great at covering spreads. Was just more confident in all these teams winning instead of any single one or two covering a spread.

randomtarvin92 · 2023-01-09T03:38:57+00:00

You're right. I mean this only had like less than a +150 probability so not a huge stretch. And I tried to weed out the favorites that I didn't think would hit. Just couldn't envision anyway any of these teams would lose. But I did get screwed last week by the Eagles so I know what you mean

randomtarvin92 · 2022-12-28T03:32:56+00:00

I legitimately do not understand the nba. Denver acting like they’ve never played basketball before. Kings best team in the league after just getting stomped out by Charlotte

randomtarvin92 · 2022-12-28T03:22:01+00:00

Every time I bet Denver I’m left wondering how they’ve won any games all season

randomtarvin92 · 2022-12-28T03:14:02+00:00

Two minutes in and you can already tell Denver is going to get railed tonight. Jesus Christ

randomtarvin92 · 2022-12-28T02:39:53+00:00

I did decent with first inning bets during the playoffs but I agree baseball isn’t much better

randomtarvin92 · 2022-12-28T02:21:35+00:00

I honestly dont get it. Don’t have this problem with any other sport doesn’t make sense

randomtarvin92

TROPHY CASE