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