Beatrice | smart home device works with Google Home

I have a family tree with 4 generations. I have put them into named groups of Parent and Child, for a child in 1st generation becomes a Parent in 2nd generation and so forth.

I can easily, pending some rules, decide what Parent resides in 1st generation and a list of Children from Parent.

When you work with this for a while you start to recognise a system of Children in the 4th generation, and you then just select that Child and from that choise I can then select (XLOOKUP, VLOOKUP) who is the Parent of selected Child.

My problem comes when my children Peter, Joe, Beatrice, Jim, Joe suddenly gets an overlap. The 2 Joes which normally have 2 different parents now only have 1, due to LOOKUP only finding the first solution.

I can easily make a FILTER of which Parents are linked to a Child, and list them seperately but I need that FILTER inside a Data Validation (Drop Down). I have tried the INDIRECT solution and it didn't work as intended. FILTER(Parent;Child=D5)

The function I'm using right now is XLOOKUP(D1;Child;Parent;"not found";0;1) , that works brilliantly when the family tree is straight up and clear. I select the Child, it finds the Parent, which in turn find the (Grand)Parent, etc. When I do find a Joe it returns the Parent of the 1st Joe in the system, messing up the family trees.

Optimally I would have a Drop Down of the possible Parents of this Joe and then the family tree would continue.

(There's a client and level of IP involved. The specific word is 'Other' and several trees are using the word to describe a group of products. Due to IP I can't change any names or make it Joe 1, Joe 2, etc)

I have 1000s of rows of this, when I've selected a family/product-line for a row that row is done. I can't feasible allocate that Drop Down out. The filter needs to be incl in the Drop Down/Data validation menu. Each time the client returns with a new Workbook, I'd prefer I just copy-paste the logic and easily covering the 1000s of rows.

4 generations and 5 families. If for each generation there'd be a drop down of Parents for a Child, that would solve for those families with a Joe.

So I have this table and I am trying to sort it such that the values of the 'Sex' column are alternating. Below is the table in question

Hello great people of SO!

I hope you all have a good day and have a good health

Note: I'm not good at SQL

Sorry for bad english, but I will try my best to explain my issue

I'm using Laravel v8.x for my app, and after setting up model relationships, events, queues, etc, now I'm working for SQL

ATM, I have 2 Models,

• User
• Post

Relationships:

• User hasMany Post
• User belongsToMany User (Block)
• User belongsToMany User (Follow)
• Post belongsTo User

Database: 5 record for User 2 record for Block 3 records for Post

Table: (Using faker)

users

following are my files for html, .ts and json . As json data was very extensive therefore i have just added a few states and their cities. my 1st dropdown is showing all states. Now I want to match my 1st dropdown's selected value of state with a key "state" in "cities" object in my json file so i can populate 2nd dropdown with cities relevant to that state. and I want to do this in function "getCitiesForSelectedState". please help me find solution for this.

//.ts file

I have made a code in JavaScript to concatenate two arrays of names and sort them out without duplicate. When it shows on the screen I don't see the item 0 of my new array. I don't know why, in the console.log I see the item 0 which is "Alice". But, what I actually see on the webpage is 1. William, 2. Beatrice, 3. Charlie, 4. Charlotte, etc.

This question is sequelize specific but I'd figure if I found a way to do in SQL then I could find a way to do it in sequelize

I need for the request to be ordered back by user.fullname which is joined by using include and by mockUser.fullname which is a JSON field.

One important thing to keep in mind however is that user is nullable in the case a mockUser is present.

This is what I have so far, it is ordering by mockUser.fullname and user.fullname, However, it is doing so separately, meaning there are two correct orders but they're not ordered into one single order which is the desired result.

Let's have an employee hierarchy given with the following table:

I am trying to grab all the names from this following Wikipedia page: https://ro.wikipedia.org/wiki/List%C4%83_de_prenume_rom%C3%A2ne%C8%99ti

This is the code I'm running:

I have a list called transactions_clean, cleaned up from whitespace etc., look like this: