-
SQL, extract unique values of JSON format field from each group
Application • 0 Reply • 448 View • 2024-09-04 15:43 -
Parse a csv file having a primary-sub tables structure
Application • 0 Reply • 310 View • 2024-09-03 16:26 -
Find how many times two specified members will be contained in a series of sets
Desktop • 0 Reply • 389 View • 2024-09-03 16:24 -
-
-
Process a large csv file with parallel processing
Application • 0 Reply • 249 View • 2024-09-02 16:10 -
Split each row into multiple rows according to the specified rule
Desktop • 0 Reply • 230 View • 2024-09-02 16:09 -
Concatenate column titles corresponding to empty cells
Desktop • 0 Reply • 189 View • 2024-08-30 15:09 -
-
Split values of a field in a database table and transform it to new fields
Application • 0 Reply • 175 View • 2024-08-30 11:25 -
-
-
Get the whole group where at least one member meets the specified condition
Application • 0 Reply • 207 View • 2024-08-28 14:34 -
Combine cell values of every 3 rows under each column into one cell
Desktop • 0 Reply • 238 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 • 250 View • 2024-08-27 14:58 -
Get desired data every N rows and combine them into one row
Desktop • 0 Reply • 340 View • 2024-08-26 14:10 -
-
Java, perform COUNT on each group of a large csv file
Application • 0 Reply • 264 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 • 233 View • 2024-08-22 16:21 -
Get rankings of Excel rows in each group while retaining the existing order
Desktop • 0 Reply • 265 View • 2024-08-22 16:06 -
Group and Summarize data, and align to the specified sequence
Application • 0 Reply • 192 View • 2024-08-21 15:00 -
-
Group an EXCEL table and concatenate values of rows meeting the specified condition
Desktop • 0 Reply • 234 View • 2024-08-20 15:03 -
SQL, compute cumulative sums according to the termination condition
Application • 0 Reply • 233 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 • 216 View • 2024-08-19 14:03 -
-
SQL, concatenate multiple rows of strings and remove duplicates
Application • 0 Reply • 210 View • 2024-08-16 15:26 -
SQL, output associated records having many-to-many relationship row by row
Application • 0 Reply • 201 View • 2024-08-15 15:54