-
blackduckie • Desktop • 1 Reply 615 View • 2020-11-12 15:30:55
Group & Summarize a Big Excel File Every N Rows
-
-
blackduckie • Desktop • 1 Reply 575 View • 2020-12-02 14:05:30
How to Use SQL to Query Data in Excel
-
blackduckie • Desktop • 1 Reply 508 View • 2020-12-03 18:12:06
Get the Previous & Next Row of Same Group without Sorting the Excel Data
-
blackduckie • Desktop • 1 Reply 520 View • 2020-12-04 16:37:33
Group & Summarize an XLS file without Using Excel
-
blackduckie • Desktop • 1 Reply 556 View • 2020-12-04 17:21:54
Execute Excel-like Formulas outside Excel
-
blackduckie • Desktop • 1 Reply 417 View • 2020-12-06 16:32:59
Directly Query Excel/Text Files Using SQL
-
-
blackduckie • Desktop • 1 Reply 488 View • 2020-12-14 09:17:30
Extend One Row to Multiple Rows by a Specific Rule
-
blackduckie • Desktop • 1 Reply 568 View • 2020-12-15 18:55:49
Convert a Multi-row-based Table to a Regular Row-wise Table
-
blackduckie • Desktop • 1 Reply 703 View • 2020-12-22 16:38:59
How to Split a Large Excel File into Smaller Files
-
blackduckie • Desktop • 1 Reply 517 View • 2020-12-22 17:49:25
Split an Excel Table by Time Interval and Expand It Horizontally
-
blackduckie • Desktop • 1 Reply 468 View • 2020-12-23 09:59:04
How to Parse KV Format(key=value) Excel Cells
-
-
blackduckie • Desktop • 1 Reply 560 View • 2020-12-11 17:18:34
Group Excel Data and List Column Values Horizontally in Specific Order
-
blackduckie • Desktop • 1 Reply 465 View • 2021-01-29 17:42:02
How to List All Permutations of Members from Multiple Sets
-
blackduckie • Desktop • 1 Reply 555 View • 2021-02-01 08:37:15
How to Select Records by Specified Percentage of a Specific Field
-
blackduckie • Desktop • 1 Reply 582 View • 2021-02-01 08:39:58
How to Achieve Interval-based VLOOKUP in Excel
-
blackduckie • Desktop • 1 Reply 406 View • 2021-02-01 09:14:15
How to Get the Maximum Value in Continuous Non-null Cells
-
blackduckie • Desktop • 1 Reply 1,763 View • 2021-01-27 15:20:04
How to Convert a Grouped Excel File That Contains Merged Cells into JSON Format
-
blackduckie • Desktop • 1 Reply 1,540 View • 2020-12-08 19:53:50
Extract Data from a Specifically-patterned TXT File to Export to Excel
-
blackduckie • Desktop • 1 Reply 512 View • 2021-01-27 10:45:40
How to Combine Rows and Columns of Multiple CSV Files
-
blackduckie • Desktop • 1 Reply 408 View • 2021-01-25 17:14:11
How to Get the Next Value of the Cell Meeting the Specific Condition
-
blackduckie • Desktop • 1 Reply 364 View • 2021-01-25 16:00:07
How to Group Rows, Perform Distinct and Then Transposition
-
blackduckie • Desktop • 1 Reply 501 View • 2021-01-25 15:02:55
How to Insert an Empty Row Wherever the Excel Cell Value Is Changed
Recent hot
- Local Data Analysis: DuckDB or esProc SPL?
- SPL assists MongoDB: Aggregation nested $group
- SPL Operates Multi-layer JSON Data Much More Conveniently than DuckDB
- SPL assists MongoDB: To filter a JavaScript array based on matches
- SPL assists MongoDB: Replace substring in array of objects with nested objects
- Comparison of esProc SPL and DuckDB in Multi-Data Source Capabilities
- SPL assists MongoDB: Convert response into array of object
- SPL assists MongoDB: Only keep the running total for the last item in the partition
- esProc SPL vs DuckDB: Which is more Lightweight for In-Application Computation
- How to execute SQL on CSV files with esProc SPL