Questions tagged [rows]

A row is a single data item in a database, spreadsheet, table, grid or list. When using this tag, please also add additional tags to clarify your specific environment/language/use case.

A row is a single data item. In the context of a database or similar data structure, it's also known as a or and will have a well-defined structure. In the context of a dataset in data science, each row represents an observation.

Rows can also be added to a less structured data source, such as a , , grid or .

4419 questions
1
vote
1 answer

Looping through table rows + grabbing attributes

I'm trying to loop through table rows, pass in an object, grab each row's data-filter, and check it against the data I'm passing in (key value pairs). My below code isn't grabbing the data-filter value. What am I doing wrong? HTML
codinginnewyork
  • 1,008
  • 2
  • 12
  • 17
1
vote
1 answer

Transforming Data in SQL Server

I am new here so please bear with me if this type of question has already been asked, and I am going to try and be as clear as possible. With that said, I am at whits end trying to transform the data table below into the format required. All ideas…
Mitchel
  • 13
  • 4
1
vote
1 answer

How to get list of all possible sums of n*m matrix rows

I have this 4x10 (nxm) data matrix in csv: 1, 5, 19, 23, 7, 51, 18, 20, 35, 41 15, 34, 17, 8, 11, 93, 13, 46, 3, 10 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 10, 9, 8, 7, 6, 5, 4, 3, 2, 1 First, I try to get a list of all possible sums from the first n/2 rows.…
Erba Aitbayev
  • 4,167
  • 12
  • 46
  • 81
1
vote
2 answers

VBA: insert a variable number of rows

I've written the code below but I can't get past a line where I want to insert a variable number of rows. The compiler screams that it needs a "list separator or )" where there is a colon. But I can't find other ways of writing this. Please, help!…
Lola
  • 97
  • 4
  • 11
1
vote
3 answers

Split a column in lines after every 5 entries - awk

I have a file that looks like the following 1 1 1 1 1 1 12 2 2 2 2 2 2 2 3 4 What I want to do is convert this column in multiple rows. Each new line/row should start after 5 entries, so that the output will like like this 1 1 1 1 1 1 12 2 2 2 2 2…
Thanos
  • 594
  • 2
  • 7
  • 28
1
vote
3 answers

iOS Swift How to Extract Strings from All Selected Rows in a TableView

I want to loop through a TableView and extract the text from all the selected rows. I suppose I "could" create and maintain a special array that is updated every time a row is selected/deselected using the didSelect/didDeselectRowAtIndexPath…
dimery2006
  • 335
  • 1
  • 5
  • 13
1
vote
2 answers

How to add rows with 0 counts to summarised output

I have added sample data below, I have used dplyr to count on Rco and month: structure(list(Rco = structure(c(1L, 1L, 1L, 1L, 2L, 2L, 2L, 2L, 3L, 3L, 4L, 4L, 4L), .Label = c("A220", "B334", "C123", "D445" ), class = "factor"), month =…
rantish
  • 79
  • 1
  • 8
1
vote
2 answers

MySQL - Grouping multiple rows where criteria is the same

I have a table of movie ratings that contains millions of rows containing userid's, movieid's and ratings. | userId | movieId | rating | ------------------------------ | 1 | 213 | 5 | | 1 | 245 | 4 | | 2 | 213 |…
dmbll
  • 113
  • 6
1
vote
1 answer

spliting rows in crosstab jasper-report

i'm working with jasper-report, i have this report i want to generate i have created a class in java, in which i have a field natureIntervention displayed on the columns, atelier on the rows and numero used for the count in the crosstab public…
Bilal Dekar
  • 3,200
  • 4
  • 28
  • 53
1
vote
2 answers

Data that is echoed is not in correct rows

Not quite sure how to explain this but i think the picture says it all. I am trying to popular the table with data from my database. Very lost and confused as to how i get it correct. Thank you Want to retain my checkbox sum function undesired…
AshKenth
  • 29
  • 5
1
vote
0 answers

Parsing +8000 rows php for +6 hours (ajax)

I'm parsing data from a sitemap so here is the process: Get sitemaps from $directory as the website split his sitemap explore sitemaps one by one and get urls that interest me Get attributes from each url as title,description,price .... connect…
ayoub
  • 11
  • 2
1
vote
2 answers

SQL combine rows for date table

I need to make a date table to use for a search criteria for a query. I'm basically trying to make a table that gets the last Sunday of the previous year, to the last Saturday of the current year. I also need to combine the rows. Example: "1",…
user41829
  • 95
  • 1
  • 1
  • 10
1
vote
1 answer

C# ClosedXML WorkSheets Add's 1048576 empty rows

I've been trying to find a solution for this but haven't been able to find any yet. So what is happening is that when I do: IXLWorksheet sheetSave = wb.Worksheets.Add("SheetName"); I get an Excel sheet that as 1048576 rows and 20Columns. If I send…
Morce
  • 51
  • 1
  • 10
1
vote
1 answer

How can I update 15 rows every 2 seconds?

On an Oracle DB, if I have a table with an arbitrary number of rows. What is the simplest way of running an update query that will update the first 15 rows, then wait 2 seconds, then update the next 15 rows, then wait 2 seconds, then update the next…
Stephen Walsh
  • 815
  • 4
  • 18
  • 34
1
vote
3 answers

Displaying number of rows with the same value into label

Please help me in figuring this one out. So I am trying to display the number of records with the same value into a label in my form. SELECT Status_ , COUNT(Status_) FROM ISSUANCE WHERE Status_ = 'Draft' GROUP BY Status_ How can I display it?…
noob-programmer
  • 61
  • 1
  • 1
  • 8