Hale | Botnet command & control monitor | Runtime Evironment library

Backstory: I have created a bunch of stored procedures that analyze my client's data. I am reviewing a list of vendors and trying to identify possible duplicates. It works pretty well, but each record has 2 possible addresses, and I'm getting duplicate results when matches are found in both addresses. Ideally I'd just need the records to appear in the results once.

Process: I created a "clean" version of the address where I remove special characters and normalize to USPS standards. This helps me match West v W v W. or PO Box v P.O. Box v P O Box etc. I then take all of the distinct address values from both addresses ([cleanAddress] and [cleanRemit_Address]) and put into a master list. I then compare to the source table with a HAVING COUNT(*) > 1 to determine which addresses appear more than once. Lastly I take that final list of addresses that appear more than once and combine it with the source data for output.

Problem: If you view the results near the bottom you'll see that I have 2 sets of dupes that are nearly identical except for some slight differences in the addresses. Both the Address and Remit_Address are essentially the same so it finds a match on BOTH the [cleanAddress] and [cleanRemit_Address] values for "SouthWestern Medical" and "NERO CO" so both sets of dupes appear twice in the list instead of once (see the desired results at the bottom). I need to match [cleanAddress] OR [cleanRemit_Address] but I don't know how to limit each record appearing once in the results.

• SSMS 18
• SQL Server 2019

Queries:

I am having trouble writing my json data to a google sheet - I get the exception "The number of rows in the data does not match the number of rows in the range."

I think the problem is with how the range is set - but I don't know how to fix it. I include a sample of the json data after this script:

is there a way to move the y-Axis to the right, so that the gap between the y-Axis and the first bar is 0?

So far i've tried the axis() command to make a new y-Axis. But i always get the same one shown above.

Here is a sample of the dataset:

I was playing with Mongodb and wanted a query that use lookup and $push or $addToSet

See this https://mongoplayground.net/p/4hSPKW_bCdM

How can i make this query correct. do we need loop over here ?

Should return

I have 2 pandas dataframes:

1. state abbreviations and states.
2. state names and all the national parks in each state. This is not the whole dataframe.

I need to search for a user input in the state dataframe, in this case the state abbreviation, then take the adjacent value, the full name and use that to display the correct column from the parks dataframe. I am sure this could be easier if they were one dataframe, but I could not figure a way to do that and keep all of the functionality; I want to be able to display the state dataframe for the user. Any suggestions would be really appreciated. here is my code. Around line 72 I could use help. I kept as much out as i could while keeping this functional, it is a large program, but this is my biggest problem so far. thank you

EDIT: The problem ended up to be that TERR 5.1.0 is actually based on R 3.6. and therefore Rtools35 was needed. The second problem was that I was trying to install the packages to a network location that was set as default for Rstudio due to the fact that it is installed within Parallels VM.

I've been struggling with this problem for the last few days. There are many posts on how to solve issues with rtools40, and I read everything I could find, but it still didn't solve this issue. It could be that the issue stems from the fact that I have to use Rstudio and TERR (TIBCO Enterprise Runtime for R =) and not R, and also everything is run within Parallels VM.

When installing a package (in this case it's Vegan, but also tried devtools, tidyverse and others) I get these are the errors:

I use Next.js and I'm getting a content key from an API call. I am trying to render this content key with dangerouslySetInnerHTML, but I'm getting an error :(

Error: Error Image

My Function

I have the below toy dataset which is representative of a much larger data. However, these are the columns of importance. I'm attempting to check whether the values in Dataframe match the reference dataframes Reference_A, Reference_B, and Reference_C.

I have 1 dataframe of data and multiple "reference" dataframes. I'm trying to automate checking if values of the dataframe match the values of the reference dataframes. Importantly, the values must also be in the same order as the values in the reference dataframes. These columns are of the columns of importance, but my real dataset contains many more columns.

Below is a toy dataset.