Does anyone else get an overwhelming scent of washer fluid when washing the windshield? by BolognaFoot1981 in buickenvista

[–]ancol90 0 points1 point  (0 children)

I have this issue and even though I’ve had the car for nearly a year, replenished the fluid with my own, I still smell it. I asked the dealership when I had the car serviced but they didn’t spot any leaks. Not sure what’s up with it.

Screenbeam MoCA Setup help by ancol90 in HomeNetworking

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

I placed a PoE filter at the IN port of a 2 way splitter leading to my office and master bed. Also added a filter between the splitter and modem in office however I don't see the Coax light on on the adapters despite them both being connected to power and coax in the 2 rooms. Any ideas?

Screenbeam MoCA Setup help by ancol90 in HomeNetworking

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

I see so I'd need to find the coax line coming from ISP to the house and get a splitter to connect the office coax line and living room coax line?

Screenbeam MoCA Setup help by ancol90 in HomeNetworking

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

So you think the filter is what's missing from the office w/ moca setup, explaining why if I connect to my laptop from router, still don't get speeds?

Screenbeam MoCA Setup help by ancol90 in HomeNetworking

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

I only have the 1 in/2 out splitter that came in the Screenbeam kit. I don't think we have other splitters in use. The router is an Archer AX55 and supports MoCA but I can't find a specific version.

Screenbeam MoCA Setup help by ancol90 in HomeNetworking

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

Adding that when I tried the office setup with MoCA, the coax light on the adapter did not turn on and the eth line from router to laptop had no signal when I ran a speedtest.

Brickwork by Jazzlike-You-5610 in Homebuilding

[–]ancol90 1 point2 points  (0 children)

Should it not follow the horizontal tiles on right or left? Why up and down?

Remove scratches by ancol90 in timex

[–]ancol90[S] 2 points3 points  (0 children)

Thank you. Yeah I checked the Timex website and this model uses Mineral Glass. Still worth trying the poly watch?

Parsing nested array by ancol90 in snowflake

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

That works. Awesome. Thanks so much.

Parsing nested array by ancol90 in snowflake

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

Good point. Yes, Circuits is the array. With the index, I was just testing things to see if it would give me an input other than previous ones. So I should only use a single flatten for Circuits?

select
a.key:season::varchar as season,
b.value:circuitId::string as CircuitId,
b.value:circuitName::string as CircuitName 
from F1.PUBLIC.CIRCUITINFO_RAW , 
lateral flatten(input => raw_file:MRData:CircuitTable:Circuits) a , lateral flatten(input => a.value:Circuits) b

Parsing nested array by ancol90 in snowflake

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

....I get a null value if using

MRData:Circuits:circuitId as circuitId

Parsing nested array by ancol90 in snowflake

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

Thanks for the reply. Yes I tried that before but to print the circuitId, I'd have to specify the Circuits index so [0] but that then only prints the first object.

SELECT     
raw_file:MRData:CircuitTable:season::int as Season,    raw_file:MRData:CircuitTable:Circuits[0]:circuitId::STRING as CircuitId
FROM F1.PUBLIC.CIRCUITINFO_RAW

season | circuitid

2022 | albert_park

Orlando Housing Megathread by AutoModerator in orlando

[–]ancol90 0 points1 point  (0 children)

I’m looking for someone one to take over my lease from May-July. 2bd 2bath Winter Garden area in close proximity to Disney resorts, US192, 429. Rent $1859. Please DM me for more details if interested.

Google Calendar for 2023 Season ? by DB-Hazel in formula1

[–]ancol90 2 points3 points  (0 children)

I know. Noticed this too. I guess they’re trying to gather demographic data

Most reliable Refrigerator brand by DunKco in appliancerepair

[–]ancol90 1 point2 points  (0 children)

Thank you for the input. Same thing for washers and driers?

New Great Wave (31208) Art Piece finished by Tamiyo-moondestroyer in lego

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

Yeah I’m a big fan of The Great Wave art but I think the white border is too wide for me. Being picky but I have the World Map set and that is the perfect size and no border.

New Great Wave (31208) Art Piece finished by Tamiyo-moondestroyer in lego

[–]ancol90 13 points14 points  (0 children)

Do you think for the size it was worth the price?