• •      •    364 View    •   2019-09-14 04:10:51

## One Row to Multiple Rows – Case 4

• •      •    379 View    •   2019-09-14 03:33:41

## One Row to Multiple Rows – Case 3

• •      •    369 View    •   2019-09-12 16:00:32

## Find Whether a Value is Up or Down

• •      •    359 View    •   2019-09-12 09:18:13

## Inter-row Calculations – Record Reference

• •      •    438 View    •   2019-09-12 08:33:14

## Inter-row Calculations - Calculate Store

• •      •    378 View    •   2019-09-12 07:33:16

## Calculate Continuous Ups & Downs

• •      •    287 View    •   2019-09-12 06:49:06

## A Tip for Calculating Account Balance

• •      •    387 View    •   2019-09-12 05:48:53

## Handle Commas inside a Quotation Mark

• •      •    288 View    •   2019-09-12 02:34:45

## Join Up Multiple Same-format 2D Tables

• •      •    392 View    •   2019-09-11 08:59:32

## Dynamic Interval Location

• •      •    384 View    •   2019-09-11 08:31:30

## Accumulation by Interval

• •      •    425 View    •   2019-09-11 07:08:35

## Dynamic Row-to-Column Transposition – Case 3

• •      •    347 View    •   2019-09-11 06:57:10

## Order-based Calculations – Get the Last Record of a Group

• •      •    380 View    •   2019-09-11 06:10:23

## Order-based Calculations – Compare First Two Records in a Group

• •      •    422 View    •   2019-09-11 05:26:30

## Crosstab Grouping & Concatenation

• •      •    428 View    •   2019-09-11 02:32:08

## Get a Substring between Specified Positions/Separators in DB2

• •      •    396 View    •   2019-09-11 01:20:45

## Order-based Set Operations – Get Values by Foreign Key

• •      •    375 View    •   2019-09-10 18:45:13

## One Row to Multiple Rows – Case 2

• •      •    401 View    •   2019-09-10 18:29:33

## Order-based Calculations – Find Difference between Two Columns Recursively

• •      •    361 View    •   2019-09-10 12:18:46

## Order-based Calculations – Group by Comparing Neighboring Values & Find Cumulated Time

• •      •    336 View    •   2019-09-10 08:38:08

## Order-based Calculations – Find Records That Are Not in Ascending Order

• •      •    302 View    •   2019-09-10 07:16:31

## Group Values in Each Column for an Aggregation

• •      •    323 View    •   2019-09-10 06:47:01

## Find Unique Columns from Text Files

• •      •    388 View    •   2019-09-10 06:28:46

## Write Space-separated Text Files to an Excel File

• •      •    369 View    •   2019-09-10 05:47:04