Tag: rows

Google Sheets Query, filtering by rows and columns?

Is there a way to use QUERY formula in Google Sheets, filter results by row AND columns? Basically, I need to filter the results using two filters. Columns must be filtered by a number between 4 and 10, but their position may vary. So our reference is the value of the first line …. You can not trust the position of a column because it can change ….

For example:

         A          B        C                  D        E  
-----------------------------------------------------------------
   1 | -----        5        6                  7        8
   2 | Speed        Slow     Fair               Medium   Fast  
   3 | Comfort      Bad      Barely acceptable  Bla      Bla,bla                
   4 | Reliability  Low      Acceptable         Blabla   Blablabla

Then something like:

=QUERY('Sheetname'!A1:E; "Select xxx where A = 'Speed')

In the example above, xxx must filter the columns using the numeric value of line 1 ….

the keyboard keys in rows A and Z do not work properly

I have a Dell Latitude laptop. There was a problem with the keyboard, it was only with A and Z Row when I was pressing a or z, it was typing "az" and whenever I was pressing S or X, he was typing "sx"; Fortunately, he was covered by the guarantee. They check to see if it's a problem with the keyboard language configuration, then ask me to update the driver, but not yet resolved. Then told me to go to the bios option and ask to type there, but the same problem also existed. They therefore confirmed that it was a material problem. Send engineer with keyboard. It matches the same problem keyboard was repeated. Then he said that this could be a problem with the motherboard, so replace the motherboard but the problem was still there. Now, I do not see any other option what is the real problem. Please suggest if all ..

SQL Server – Naming – 1 million rows in less than 1 second

I have the obligation to match the name blur for about 1 million lines in less than a second. I'm using a simple Jaro Winkler function for a row of 20k, its execution costs about 5 seconds and the rate increases exponentially.

Note that the actual function is much more complicated than that because it involves several fuzzy name matching techniques.

Well, honestly, I do not know how to match it at this rate. Note that there is no second identifier to filter (for example, nationality, etc.). Only the name is used for correspondence to the screen on a list of about 1 million lines with fuzzy name matching.

mysql – Deleting rows with a date / time older than one hour from a custom database table

I'm trying to remove all lines from a custom WordPress database table whose date / time is less than one hour.

However, in my case, every line is deleted, even those created a minute ago. I've tried some versions of MySQL to set the date, but the result is the same each time.

I'm a little stuck, ideas where I could be wrong?

$delete_sql = "
    DELETE
    FROM {$wpdb->prefix}api_prices
    WHERE date_added < %s
";

$wpdb->query($wpdb->prepare($delete_sql, 'DATE_SUB(NOW(), INTERVAL 1 HOUR)'));

Creating Google Form and adding multiple rows

How to add multiple lines in Google Form when creating an online employee data form.

dataset – How to count n observations / rows in a table?

What is the expression for counting lines / observations?

  1. Here's how I entered the data: 
Module[{path, nb}, 
 path = FileNameJoin[{NotebookDirectory[], "dataintro.nb"}];
 nb = NotebookOpen[path, CellContext -> "Global`", Visible -> False];
 NotebookEvaluate[nb, InsertResults -> False];
 NotebookClose[nb]]
  1. My data looks like the table format with variables: Feet and price

Thank you for your help!

c # – How to get data from a column containing multiple rows of datagridview and save them to a SQL server

I have a problem, I would like to save the column to several lines of a .dgv file in the SQL database … Example
In the dgv 

|ID | | Detalle |.                                                                                            
 1      Polo.                                                                                                    
 2      Camisa.                                                                                                 
 3     Bermuda

I would like to save it in my sql array this way 

|ID | |Detalle|.                                                                                                                                                                     
  1      polo, camisa , bermuda

I hope to have explained

I do it in C #

sql – Filters the rows according to the value of a column of a particular line

Here is the code

-- How many users earned a particular tag based badge sooner than I did?

DECLARE @BadgeName nvarchar(255) = '##BadgeName##'
DECLARE @BadgeType int = ##BadgeType## -- 1: Gold, 2: Silver, 3: Bronze
DECLARE @UserId int = ##UserId##

SELECT
Users.DisplayName,
Users.Id,
DATEDIFF(day, Users.CreationDate, Badges.Date) AS Days
FROM Badges
  INNER JOIN Users ON Users.Id = Badges.UserId
WHERE
  Badges.Class = @BadgeType
  AND Badges.TagBased = 1 -- for true
  AND Badges.Name = @BadgeName
  AND DATEDIFF(day, Users.CreationDate, Badges.Date) <=
    (SELECT DATEDIFF(day, Users.CreationDate, Badges.Date)
    FROM Badges
      INNER JOIN Users ON Users.Id = Badges.UserId
    WHERE
      Badges.Class = @BadgeType
      AND Badges.TagBased = 1 -- for true
      AND Badges.Name = @BadgeName
      AND Badges.UserId = @UserId)
ORDER BY Days Asc

Does the song below do the same thing twice?

(SELECT DATEDIFF(day, Users.CreationDate, Badges.Date)
        FROM Badges
          INNER JOIN Users ON Users.Id = Badges.UserId
        WHERE
          Badges.Class = @BadgeType
          AND Badges.TagBased = 1 -- for true
          AND Badges.Name = @BadgeName
          AND Badges.UserId = @UserId)

I wonder if there is a way to make it less redundant?

Can be run at https://data.stackexchange.com/stackoverflow/query/1111754/vanity-how-many-users-earned-a-particular-tag-based-badge-sooner-than-i -did for tests.

ssms – rows removed by SQL Server itself

This is possible for SQL to automatically delete some lines from a table? That happened to me twice. Already checked for stored procedures and DELETE FROM queries in my code. I have my table inventory, it has no foreign key, yesterday before leaving the office, the information was there and today, only the information on the stock for a certain category was not there. Nobody has access to this information.

The newspaper shows nothing related to this. I work with MSSQL Server 2016 in the Windows server.

Thank you.

Excel formula to fill every 3 rows in a column from the values ​​of all 3 cells of an adjacent column

I am looking for a way to populate all 3 rows in a column from the values ​​of all 3 cells of an adjacent column.

I'm trying to start from this:

Unpopulated column

For that:-

Column filled

I have thousands of lines, so I try to find a way to make it as painless as possible.

Thank you