esProc Desktop's Blog

esProc Desktop's Blog

Follow

Follow

#70 — Search by Adjacent Rows

#70 — Search by Adjacent Rows

Problem description & analysis: We have a statistical table for daily sales of January 2022: Task: Now we want to find out the data of date where the previous and next day’s sales are both more than 500 lower than that of the date. Solution: Use SPL...

esProc Desktop

#69 — Filter by Multiple Conditions

#69 — Filter by Multiple Conditions

esProc Desktop

#68 — Search for Rows That Satisfy The Condition

#68 — Search for Rows That Satisfy The Condition

esProc Desktop

#67 — Search for Row Numbers That Satisfy The Condition

#67 — Search for Row Numbers That Satisfy The Condition

#66 - Search for The Position of A Certain Value And Take Values by Position

#66 - Search for The Position of A Certain Value And Take Values by Position

#65 — Filter Rows by Position

#65 — Filter Rows by Position

#64 — Search for Top N Values And Last N Values

#64 — Search for Top N Values And Last N Values

#63 - Search for The Nth Value And The Nth Value from Last

#63 - Search for The Nth Value And The Nth Value from Last

#62 - Search for A Specified String across The Whole Table

#62 - Search for A Specified String across The Whole Table

Split Words as Individual Characters

Split Words as Individual Characters

#60 - Find How Many Times Two Specified Members Will Be Contained in A Series of Sets

#60 - Find How Many Times Two Specified Members Will Be Contained in A Series of Sets

#59 - Split IP Addresses And Then Group Rows

#59 - Split IP Addresses And Then Group Rows