-
Split values of a field in a database table and transform it to new fields
Application • 0 Reply • 206 View • 2024-08-30 11:25 -
-
-
Get the whole group where at least one member meets the specified condition
Application • 0 Reply • 240 View • 2024-08-28 14:34 -
Combine cell values of every 3 rows under each column into one cell
Desktop • 0 Reply • 304 View • 2024-08-27 16:25 -
Parse a csv file where field values are enclosed by quotation marks and contain carriage return
Application • 0 Reply • 289 View • 2024-08-27 14:58 -
Get desired data every N rows and combine them into one row
Desktop • 0 Reply • 383 View • 2024-08-26 14:10 -
-
Java, perform COUNT on each group of a large csv file
Application • 0 Reply • 297 View • 2024-08-23 15:29 -
-
Java, fill each row having a null value in a csv file with values in the directly previous row
Application • 0 Reply • 260 View • 2024-08-22 16:21 -
Get rankings of Excel rows in each group while retaining the existing order
Desktop • 0 Reply • 313 View • 2024-08-22 16:06 -
Group and Summarize data, and align to the specified sequence
Application • 0 Reply • 224 View • 2024-08-21 15:00 -
-
Group an EXCEL table and concatenate values of rows meeting the specified condition
Desktop • 0 Reply • 288 View • 2024-08-20 15:03 -
SQL, compute cumulative sums according to the termination condition
Application • 0 Reply • 276 View • 2024-08-19 17:39 -
-
In an Excel table, find rows corresponding to the 1st and the last non-empty cells in each column
Desktop • 0 Reply • 252 View • 2024-08-19 14:03 -
-
SQL, concatenate multiple rows of strings and remove duplicates
Application • 0 Reply • 247 View • 2024-08-16 15:26 -
SQL, output associated records having many-to-many relationship row by row
Application • 0 Reply • 235 View • 2024-08-15 15:54 -
-
Copy each row N times (N is the cell value of the specified column)
Desktop • 0 Reply • 210 View • 2024-08-14 15:36 -
-
Group rows and combine non-null values in each of non-grouping columns
Desktop • 0 Reply • 377 View • 2024-08-09 15:40 -
-
-
-
SQL, split values of two columns respectively and count members of their intersection
Application • 0 Reply • 301 View • 2024-08-07 18:08 -
Group and summarize rows while retaining columns whose values are unchanged
Desktop • 0 Reply • 278 View • 2024-08-06 16:04