-
jinxing • Application • 242 View • 2024-08-20 15:23:32
SQL, mark continuous rows with sequence numbers
-
jinxing • Desktop • 288 View • 2024-08-20 15:03:12
Group an EXCEL table and concatenate values of rows meeting the specified condition
-
jinxing • Application • 276 View • 2024-08-19 17:39:02
SQL, compute cumulative sums according to the termination condition
-
-
-
-
jinxing • Application • 247 View • 2024-08-16 15:26:09
SQL, concatenate multiple rows of strings and remove duplicates
-
jinxing • Application • 235 View • 2024-08-15 15:54:28
SQL, output associated records having many-to-many relationship row by row
-
jinxing • Desktop • 232 View • 2024-08-15 15:52:42
Find the category meeting the specified condition
-
jinxing • Desktop • 210 View • 2024-08-14 15:36:47
Copy each row N times (N is the cell value of the specified column)
-
-
jinxing • Desktop • 377 View • 2024-08-09 15:40:14
Group rows and combine non-null values in each of non-grouping columns
-
-
-
-
jinxing • Application • 301 View • 2024-08-07 18:08:07
SQL, split values of two columns respectively and count members of their intersection
-
-
jinxing • Desktop • 278 View • 2024-08-06 16:04:13
Group and summarize rows while retaining columns whose values are unchanged
-
jinxing • Application • 407 View • 2024-08-05 17:30:22
Get duplicate records from a csv file and sort them
-
-
jinxing • Desktop • 223 View • 2024-08-05 09:25:46
Define a dynamic range of columns and perform aggregation
-
jinxing • Application • 289 View • 2024-08-02 14:02:51
Retrieve multiple columns from a csv file to generate a new file
-
jinxing • Application • 255 View • 2024-08-01 15:37:08
Clear duplicate lines and lines having missing values from a csv file
-
jinxing • Desktop • 316 View • 2024-08-01 14:32:18
Group columns of an Excel table and perform aggregation
-
jinxing • Application • 306 View • 2024-07-31 18:28:00
Merge multiple files, remove duplicates and sort the result