DEV Community

Judith-Data-Processing-Hacks profile picture

Judith-Data-Processing-Hacks

esProc Desktop is a desktop data processing & analytics tool and is specifically designed for ordinary business people, which significantly lowers the technical threshold for data analytics.

Joined Joined on  Email address judithliu@scudata.com Personal website https://www.esproc.com/download-desktop/ twitter website
8 Week Community Wellness Streak
4 Week Community Wellness Streak
2 Week Community Wellness Streak
1 Week Community Wellness Streak
Two Year Club
Writing Debut
4 Week Writing Streak
One Year Club
Search for the Closest Matching Record within the Group — From SQL to SPL #9
judith677 profile

Search for the Closest Matching Record within the Group — From SQL to SPL #9

#dataengineering #database #esprocspl #sql
6
Comments 1
2 min read

Want to connect with Judith-Data-Processing-Hacks?

Create an account to connect with Judith-Data-Processing-Hacks. You can also sign in below to proceed if you already have an account.

Create Account
Already have an account? Sign in
Calculate based on the records within the group and fill the result into the first record — From SQL to SPL #8
judith677 profile

Calculate based on the records within the group and fill the result into the first record — From SQL to SPL #8

#sql #esprocspl #datascience #database
7
Comments 1
3 min read
Uncertain Number but Regular Column to Row Conversion — From SQL to SPL #7
judith677 profile

Uncertain Number but Regular Column to Row Conversion — From SQL to SPL #7

#sql #dataengineering #opensource #esprocspl
7
Comments 1
2 min read
Align the existing data to the corresponding position and fill in any missing data with 0 — From SQL to SPL #6
judith677 profile

Align the existing data to the corresponding position and fill in any missing data with 0 — From SQL to SPL #6

#sql #opensource #mysql #esprocspl
7
Comments 1
2 min read
Flexible Interval Aggregation — From SQL to SPL #5
judith677 profile

Flexible Interval Aggregation — From SQL to SPL #5

#sql #opensource #programming #esprocspl
7
Comments 1
2 min read
Convert Cross Cell to Row Header, Row Header to Column — From SQL to SPL #4
judith677 profile

Convert Cross Cell to Row Header, Row Header to Column — From SQL to SPL #4

#opensource #sql #dataanalytics #esprocspl
7
Comments 1
2 min read
Complement a certain average value to ensure that the total sum remains unchanged — From SQL to SPL #3
judith677 profile

Complement a certain average value to ensure that the total sum remains unchanged — From SQL to SPL #3

#programming #opensource #sql #dataengineering
9
Comments 1
2 min read
Track Production Operations Outcome Progression with Conditional NULLs - From SQL to SPL #2
judith677 profile

Track Production Operations Outcome Progression with Conditional NULLs - From SQL to SPL #2

#programming #database #opensource #sql
6
Comments 1
2 min read
Do Ordered Grouping and Aggregation within Groups — From SQL to SPL #1
judith677 profile

Do Ordered Grouping and Aggregation within Groups — From SQL to SPL #1

#programming #sql #database #opensource
6
Comments
2 min read
#145 — Insert Blank Row when Meeting with Data Change
judith677 profile

#145 — Insert Blank Row when Meeting with Data Change

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#144 — Insert Row after Specific Row
judith677 profile

#144 — Insert Row after Specific Row

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#143 — Expand One Row into Multiple Rows after Splitting Text
judith677 profile

#143 — Expand One Row into Multiple Rows after Splitting Text

#programming #beginners #tutorial #productivity
7
Comments 1
2 min read
#142 — Expand One Row into Multiple Rows Based on Value
judith677 profile

#142 — Expand One Row into Multiple Rows Based on Value

#programming #beginners #tutorial #productivity
6
Comments 1
2 min read
#141 — Generate Continuous Arrays — Concatenate Results into a String
judith677 profile

#141 — Generate Continuous Arrays — Concatenate Results into a String

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#140 — Generate Continuous Arrays
judith677 profile

#140 — Generate Continuous Arrays

#beginners #tutorial #productivity #programming
6
Comments 1
1 min read
#139 — Interconversion of Rows and Columns in Reverse Order
judith677 profile

#139 — Interconversion of Rows and Columns in Reverse Order

#programming #beginners #tutorial #productivity
7
Comments 1
1 min read
#138 — Convert Certain Columns of the Same Row, as Group Members, to Multiple Rows
judith677 profile

#138 — Convert Certain Columns of the Same Row, as Group Members, to Multiple Rows

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#137 — Re-group or Sort When Filling Grouped Data into Columns
judith677 profile

#137 — Re-group or Sort When Filling Grouped Data into Columns

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#136 — Put Data in a Group Horizontally into Columns
judith677 profile

#136 — Put Data in a Group Horizontally into Columns

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#135 — Convert Crosstab to Row-Based Table
judith677 profile

#135 — Convert Crosstab to Row-Based Table

#programming #beginners #tutorial #productivity
6
Comments 1
2 min read
#134 — Convert Row-Based Table to Crosstab
judith677 profile

#134 — Convert Row-Based Table to Crosstab

#programming #beginners #tutorial #productivity
7
Comments 1
1 min read
#133 — Row-to-Column Conversion for Fixed Columns
judith677 profile

#133 — Row-to-Column Conversion for Fixed Columns

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#132 — Use Interval Range to Perform Retroactive Searching of Association Table
judith677 profile

#132 — Use Interval Range to Perform Retroactive Searching of Association Table

#programming #beginners #tutorial #productivity
1
Comments 1
1 min read
#131 — Use Association Table to Handle Interval Association
judith677 profile

#131 — Use Association Table to Handle Interval Association

#programming #beginners #tutorial #productivity
5
Comments 1
2 min read
#130 — Use Formulas to Handle Interval Association
judith677 profile

#130 — Use Formulas to Handle Interval Association

#programming #beginners #tutorial #productivity
5
Comments 1
1 min read
#129 — Multiple Column Association
judith677 profile

#129 — Multiple Column Association

#programming #beginners #tutorial #productivity
6
Comments 1
2 min read
#128 — Use Formulas to Handle Association in Excel
judith677 profile

#128 — Use Formulas to Handle Association in Excel

#programming #beginners #tutorial #productivity
7
Comments 1
1 min read
#127 — Concatenate Data Within Groups into Text
judith677 profile

#127 — Concatenate Data Within Groups into Text

#beginners #tutorial #programming #productivity
6
Comments 1
1 min read
#126 — Group When Encountering Non-Null Values
judith677 profile

#126 — Group When Encountering Non-Null Values

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#125 — Grouping Upon Encountering Blank Rows
judith677 profile

#125 — Grouping Upon Encountering Blank Rows

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#124 — Take Adjacent Data as Grouping Criteria
judith677 profile

#124 — Take Adjacent Data as Grouping Criteria

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#123 — Convert One-Dimensional Array to Two-Dimensional Array
judith677 profile

#123 — Convert One-Dimensional Array to Two-Dimensional Array

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#122 — Put Every N Members in a Group
judith677 profile

#122 — Put Every N Members in a Group

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#121 — Enumeration Grouping
judith677 profile

#121 — Enumeration Grouping

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#120 — Group by Segment
judith677 profile

#120 — Group by Segment

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#119 — Group by the Expression
judith677 profile

#119 — Group by the Expression

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#118 — Group by the Combination of Multiple Columns
judith677 profile

#118 — Group by the Combination of Multiple Columns

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#117 — Simple Grouping
judith677 profile

#117 — Simple Grouping

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#116 — Concatenate Members with the Same Ranking
judith677 profile

#116 — Concatenate Members with the Same Ranking

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#115 — Ranking of Row-Based Data — by the Expression
judith677 profile

#115 — Ranking of Row-Based Data — by the Expression

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#114 — Ranking of Row-Based Data — by the Combination of Multiple Columns
judith677 profile

#114 — Ranking of Row-Based Data — by the Combination of Multiple Columns

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#113 — Ranking of Row-Based Data
judith677 profile

#113 — Ranking of Row-Based Data

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#112 — Ranking of Simple Members
judith677 profile

#112 — Ranking of Simple Members

#programming #beginners #tutorial #productivity
5
Comments 1
1 min read
#111 — Sort in Group
judith677 profile

#111 — Sort in Group

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#110 — Sorting of Row-Based Data — by Expression
judith677 profile

#110 — Sorting of Row-Based Data — by Expression

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#109 — Sorting of Row-Based Data — by the Combination of Multiple Columns
judith677 profile

#109 — Sorting of Row-Based Data — by the Combination of Multiple Columns

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#108 — Sorting of Row-Based Data
judith677 profile

#108 — Sorting of Row-Based Data

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#107 — Sorting of Simple Members
judith677 profile

#107 — Sorting of Simple Members

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#106 — Delete Data that Can be Paired
judith677 profile

#106 — Delete Data that Can be Paired

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#105 — Filter by the Number of Duplicates
judith677 profile

#105 — Filter by the Number of Duplicates

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#104 — Deduplication of Row-Based Data — by Whole Row — Keeping the Original Order
judith677 profile

#104 — Deduplication of Row-Based Data — by Whole Row — Keeping the Original Order

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#103 — Deduplication of Row-Based Data — by Key Column — Keeping the Original Order
judith677 profile

#103 — Deduplication of Row-Based Data — by Key Column — Keeping the Original Order

#beginners #programming #tutorial #productivity
6
Comments 1
1 min read
#102 — Deduplication of Simple Data — Keeping the Original Order
judith677 profile

#102 — Deduplication of Simple Data — Keeping the Original Order

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#101 - Deduplication of Row-Based Data - by Whole Row
judith677 profile

#101 - Deduplication of Row-Based Data - by Whole Row

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#100 — Deduplication of Row-Based Data — by Key Column
judith677 profile

#100 — Deduplication of Row-Based Data — by Key Column

#beginners #programming #tutorial #productivity
7
Comments 1
1 min read
#99 — Deduplication of Simple Data
judith677 profile

#99 — Deduplication of Simple Data

#programming #tutorial #beginners #productivity
6
Comments 1
1 min read
#98 — Count Duplicates of Row-Based Data — by Key Column
judith677 profile

#98 — Count Duplicates of Row-Based Data — by Key Column

#programming #beginners #tutorial #productivity
5
Comments 1
1 min read
#97 — Count Duplicates of Simple Members
judith677 profile

#97 — Count Duplicates of Simple Members

#tutorial #programming #beginners #productivity
6
Comments 1
1 min read
#96 — Identify Duplications of Row-Based Data — by Key Column
judith677 profile

#96 — Identify Duplications of Row-Based Data — by Key Column

#beginners #programming #tutorial #productivity
6
Comments 1
1 min read
#95 — Identify Duplications of Simple Members
judith677 profile

#95 — Identify Duplications of Simple Members

#beginners #programming #tutorial #productivity
6
Comments 1
1 min read
loading...