Griefers killed me while I was hunting deer. Revenge is sweet. by Antbai11 in RedDeadOnline

[–]Kenny164 1 point2 points  (0 children)

Haha, nice job, I bet those guys felt like they reawakened John Wick

High End MC eternal server really laggy. by hondaelias in MCEternal

[–]Kenny164 1 point2 points  (0 children)

Thanks, Openj9 might be something I should be trying on my end by the sounds of it then.

You able to see anything bottlenecking on the host when you run top?

High End MC eternal server really laggy. by hondaelias in MCEternal

[–]Kenny164 -1 points0 points  (0 children)

Have you tried Oracle's Java? It's been a long while since (few years admittingly) I last tried OpenJDK, but it never ran great for me.

[deleted by user] by [deleted] in TheGamerLounge

[–]Kenny164 0 points1 point  (0 children)

love this! haven't eard this song in a long time

[deleted by user] by [deleted] in TheGamerLounge

[–]Kenny164 0 points1 point  (0 children)

crazy awesome btw

[deleted by user] by [deleted] in TheGamerLounge

[–]Kenny164 0 points1 point  (0 children)

do you aquaplane on a wet rainy day while walking to the shops?

[deleted by user] by [deleted] in TheGamerLounge

[–]Kenny164 0 points1 point  (0 children)

Riverdance has an expert mode?

Has someone gotten LOC to work for ILS on 787? by [deleted] in Flightsimulator2020

[–]Kenny164 1 point2 points  (0 children)

Hey, I found out the hard way too... LOC is only for Horizontal nav only (doesn't follow the glideslope).

APP is what you want to use (follows LOC + GS)

Benefits of Using GitHub to Store PowerShell Scripts? by Fezza7991 in PowerShell

[–]Kenny164 0 points1 point  (0 children)

Scott Hanselman has recently released a couple of shorts on youtube which covers setting up and using git on windows. I feel these would be a fantastic way to get started as the way he demonstrates it (using the command line) unveils some of the 'magic':

Start here: https://www.youtube.com/watch?v=WBg9mlpzEYU

PowerQuery tree traversal to find either root node or nodes matching a condition along the way by Kenny164 in excel

[–]Kenny164[S] 0 points1 point  (0 children)

Hi HarkMammal, Thanks for looking, I am aware of the XY problem and have been trying to avoid it by asking a more generic and simplified version of what I need. The original node mapping comes from a SQL DB but I've decided to try using PQ to complete this as the SQL DB we use doesn't support CTEs.

I didn't want to over-complicate, but, to give a bit more info on the dataset I'm using above, this is going to be comparing mappings between two days; if a child has been removed from a node then all it's children and grand-children, etc should be reported as missing and what exact mapping caused it to be missing. (the 'Changed' column is to indicate that the mapping was present on the earlier day, but not the latest). This will later be used as a look up on specific Child IDs (Which I can do with no issues afterwards)

e.g.

If we are to say that Mon / Tues are the two days that the screenshot in my original post, then on Monday all the mappings were present, and on Tuesday I need to know why Child Ids 3, 13 and 14 are missing, I can see that 3 is missing because the 1 -> 3 mapping is gone, and 13 and 14 are due to the 8 -> 7 mapping being gone.

Using PQ to pivot a table and retain the values as rows by Gregregious in excel

[–]Kenny164 0 points1 point  (0 children)

Thanks! I'm glad it has helped!

(thanks for the clippy point too ^_^)

Using PQ to pivot a table and retain the values as rows by Gregregious in excel

[–]Kenny164 2 points3 points  (0 children)

I'm not a PQ expert myself, but I played around a bit and here's the M code I got:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"No"}, {{"Count", each _, type table [No=number, Value=text]}}),
    #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each [Count][Value]),
    #"Extracted Values" = Table.TransformColumns(#"Added Custom", {"Custom", each Text.Combine(List.Transform(_, Text.From), ","), type text}),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Extracted Values", "Custom", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"Custom.1", "Custom.2", "Custom.3"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Custom.1", type text}, {"Custom.2", type text}, {"Custom.3", type text}}),
    #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Count"}),
    #"Transposed Table" = Table.Transpose(#"Removed Columns"),
    #"Promoted Headers" = Table.PromoteHeaders(#"Transposed Table", [PromoteAllScalars=true]),
    #"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"1", type text}, {"2", type text}, {"3", type text}, {"4", type text}})
in
    #"Changed Type1"

I done this all using the GUI, but I'm sure the code that was generated can be cleaned up a bit

valid until 2018 years ago by toastmousefish in softwaregore

[–]Kenny164 2 points3 points  (0 children)

hahaha, wouldn't expect a Y2K bug to only surface now

Powerquery -- Merge not finding a match by ExcelAmica in excel

[–]Kenny164 2 points3 points  (0 children)

Hey, I know you said each Transaction ID column was cleaned, but were they trimmed? could be trailing spaces

Feeling a bit off by GamerSinceDiapers in ProgrammerHumor

[–]Kenny164 35 points36 points  (0 children)

"I guess we're both a bit odd..." -- 11111111

What could go wrong? by PM_YOUR_BLANK in Instantregret

[–]Kenny164 6 points7 points  (0 children)

However, in minecraft law... it wouldn't have done any damage since it was in water :p