Judith-Data-Processing-Hacks

2 min read

Judith-Data-Processing-Hacks

Jun 16

Add Records that Meet the Criteria before Each Group after Grouping — From SQL to SPL #39

#programming #database #esprocspl #sql

2 min read

Judith-Data-Processing-Hacks

Jun 12

Count Distinct within Intervals in Order — From SQL to SPL #38

#programming #sql #database #esprocspl

2 min read

Judith-Data-Processing-Hacks

Jun 10

Conditional Grouping — From SQL to SPL #37

#programming #database #sql #esprocspl

4

2 min read

Judith-Data-Processing-Hacks

Jun 6

Change Duplicate Contents to NULL — From SQL to SPL #36

#programming #sql #database #esprocspl

2 min read

Judith-Data-Processing-Hacks

Jun 4

Get the Initial Date Using the Total — From SQL to SPL #35

#programming #database #sql #esprocspl

2 min read

Judith-Data-Processing-Hacks

May 30

Getting the Available Ranges from Two Tables — From SQL to SPL #34

#programming #database #sql #esprocspl

9

3 min read

Judith-Data-Processing-Hacks

May 28

Total under Recursive Relationship — From SQL to SPL #33

#programming #database #sql #esprocspl

2 min read

Judith-Data-Processing-Hacks

May 26

Converting JSON Data to Tabular in Snowflake — From SQL to SPL #32

#esprocspl #sql #snowflke #tabular

2 min read

Judith-Data-Processing-Hacks

May 22

Statistics by Time Window — From SQL to SPL #31

#programming #database #sql #esprocspl

10

3 min read

Judith-Data-Processing-Hacks

May 20

Segmented Accumulation by Condition — From SQL to SPL #30

#programming #database #sql #esprocspl

1 min read

Judith-Data-Processing-Hacks

May 16

Generate Calculated Columns Based on Continuous Values — From SQL to SPL #29

#programming #database #sql #esprocspl

2 min read

Judith-Data-Processing-Hacks

May 14

Find Consecutive Alphabetical Characters in String — From SQL to SPL #28

#programming #database #sql #esproc

8

2 min read

Judith-Data-Processing-Hacks

May 12

Aggregate according to Time Interval — From SQL to SPL #27

#programming #database #sql #esprocspl

9

2 min read

Judith-Data-Processing-Hacks

May 8

Create Columns from Distinct Values of a Column — From SQL to SPL #26

#programming #esprocspl #database #sql

1 min read

Judith-Data-Processing-Hacks

May 6

Substring from a Column of Strings — From SQL to SPL #25

#programming #database #sql #esprocspl

2 min read

Judith-Data-Processing-Hacks

Apr 29

Fetch Values from Previous Non-Null Value Rows — From SQL to SPL #24

#programming #database #sql #esprocspl

3 min read

Judith-Data-Processing-Hacks

Apr 27

Count Date Ranges per Year — From SQL to SPL #23

#programming #database #sql #esprocspl

8

2 min read

Judith-Data-Processing-Hacks

Apr 24

Summarize Row Counts by Dynamic Columns into JSON — From SQL to SPL #22

#programming #sql #database #esprocspl

2 min read

Judith-Data-Processing-Hacks

Apr 22

Deduplicate between an Uncertain Number of Columns — From SQL to SPL #21

#sql #database #programming #esprocsl

2 min read

Judith-Data-Processing-Hacks

Apr 18

Find the Closest Date Match for Each Record from Two Tables — From SQL to SPL #20

#programming #database #sql #esprocspl

2 min read

Judith-Data-Processing-Hacks

Apr 16

Find the Superset from the Relationship Table — From SQL to SPL #19

#dataengineering #sql #esprocspl #programming

1 min read

Judith-Data-Processing-Hacks

Apr 14

Get the Records after and before the Searched One — From SQL to SPL #18

#programming #sql #esprocspl #dataengineering

8

2 min read

Judith-Data-Processing-Hacks

Apr 11

Number Non-Null Values in Order within the Group — From SQL to SPL #17

#programming #sql #esprocspl #dataengineering

2 min read

Judith-Data-Processing-Hacks

Apr 9

Getting Values from Multiple Format Strings to Multiple Records — From SQL to SPL #16

#programming #dataengineering #sql #esprocspl

2 min read

Judith-Data-Processing-Hacks

Apr 2

Calculate all the year/months included in the year/month interval — From SQL to SPL #15

#programming #datascience #sql #esprocspl

2 min read

Judith-Data-Processing-Hacks

Mar 31

Calculate the Number of Intersections between Adjacent Subsets after Grouping — From SQL to SPL #14

#database #sql #esprocspl #programming

2 min read

Judith-Data-Processing-Hacks

Mar 26

Pair and Transpose Adjacent Records within the Group - From SQL to SPL #13

#database #dataengineering #sql #esprocspl

2 min read

Judith-Data-Processing-Hacks

Mar 24

Calculate a Pair of Minimum Values that Meet the Criteria within the Group — From SQL to SPL #12

#sql #database #dataengineering #esprocspl

2 min read

Judith-Data-Processing-Hacks

Mar 19

Calculate the Hierarchy of Recursive References — From SQL to SPL #11

#dataengineering #sql #esprocspl #database

2 min read

Judith-Data-Processing-Hacks

Mar 17

Calculate Monthly Account Balance and Fill in Missing Dates — From SQL to SPL #10

#dataengineering #database #sql #esprocspl

2 min read

Judith-Data-Processing-Hacks

Mar 12

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

#dataengineering #database #esprocspl #sql

2 min read

Judith-Data-Processing-Hacks

Mar 10

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

3 min read

Judith-Data-Processing-Hacks

Mar 5

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

#sql #dataengineering #opensource #esprocspl

2 min read

Judith-Data-Processing-Hacks

Mar 3

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

2 min read

Judith-Data-Processing-Hacks

Feb 27

Flexible Interval Aggregation — From SQL to SPL #5

#sql #opensource #programming #esprocspl

2 min read

Judith-Data-Processing-Hacks

Feb 25

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

#opensource #sql #dataanalytics #esprocspl

2 min read

Judith-Data-Processing-Hacks

Feb 21

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

#programming #opensource #sql #dataengineering

2 min read

Judith-Data-Processing-Hacks

Feb 19

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

#programming #database #opensource #sql

2 min read

Judith-Data-Processing-Hacks

Feb 18

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

#programming #sql #database #opensource

2 min read

Judith-Data-Processing-Hacks

Feb 17

#145 — Insert Blank Row when Meeting with Data Change

#programming #beginners #tutorial #productivity

1 min read

Judith-Data-Processing-Hacks

Feb 14

#144 — Insert Row after Specific Row

#programming #beginners #tutorial #productivity

1 min read

Judith-Data-Processing-Hacks

Feb 12

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

#programming #beginners #tutorial #productivity

2 min read

Judith-Data-Processing-Hacks

Feb 11

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

#programming #beginners #tutorial #productivity

2 min read

Judith-Data-Processing-Hacks

Feb 8

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

#programming #beginners #tutorial #productivity

1 min read

Judith-Data-Processing-Hacks

Feb 7

#140 — Generate Continuous Arrays

#beginners #tutorial #productivity #programming

1 min read

Judith-Data-Processing-Hacks

Feb 5

#139 — Interconversion of Rows and Columns in Reverse Order

#programming #beginners #tutorial #productivity

1 min read

Judith-Data-Processing-Hacks

Jan 27

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

#programming #beginners #tutorial #productivity

1 min read

Judith-Data-Processing-Hacks

Jan 26

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

#programming #beginners #tutorial #productivity

1 min read

Judith-Data-Processing-Hacks

Jan 24

#136 — Put Data in a Group Horizontally into Columns

#programming #beginners #tutorial #productivity

1 min read

Judith-Data-Processing-Hacks

Jan 22

#135 — Convert Crosstab to Row-Based Table

#programming #beginners #tutorial #productivity

2 min read

Judith-Data-Processing-Hacks

Jan 21

#134 — Convert Row-Based Table to Crosstab

#programming #beginners #tutorial #productivity

1 min read

Judith-Data-Processing-Hacks

Jan 20

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

#programming #beginners #tutorial #productivity

1 min read

Judith-Data-Processing-Hacks

Jan 16

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

#programming #beginners #tutorial #productivity

1 min read

Judith-Data-Processing-Hacks

Jan 15

#131 — Use Association Table to Handle Interval Association

#programming #beginners #tutorial #productivity

2 min read

Judith-Data-Processing-Hacks

Jan 13

#130 — Use Formulas to Handle Interval Association

#programming #beginners #tutorial #productivity

1 min read

Judith-Data-Processing-Hacks

Jan 10

#129 — Multiple Column Association

#programming #beginners #tutorial #productivity

2 min read

Judith-Data-Processing-Hacks

Jan 9

#128 — Use Formulas to Handle Association in Excel

#programming #beginners #tutorial #productivity

1 min read

Judith-Data-Processing-Hacks

Jan 8

#127 — Concatenate Data Within Groups into Text

#beginners #tutorial #programming #productivity

1 min read

Judith-Data-Processing-Hacks

Jan 6

#126 — Group When Encountering Non-Null Values

#programming #beginners #tutorial #productivity