esProc Desktop's Blog
Tag

data management

#data-management

More content

Read more stories on Hashnode

Articles with this tag

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

Feb 11, 20252 min read

Problem description & analysis: There is a data table, which stores some information of products. The first column is the serial number, and the...

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

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

Dec 10, 20241 min read

Problem description & analysis: Here below is a data table: Task: Rank the data (in descending order) by the order combination of three columns,...

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

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

Nov 22, 20241 min read

Problem description & analysis: There is a data table: Task: Duplicate the data and keep the original order. Solution: Use SPL XLL and enter the...

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

#89 — Calculate Proportion Using the Aggregation Values of the Data from the Same Group

Nov 5, 20241 min read

Problem description & analysis: Here below is an annual and quarterly sales data table: Task: Calculate the proportion of each quarterly sales to the...

#89 — Calculate Proportion Using the Aggregation Values of the Data from the Same Group

#87 — Merge Data of The Same Group

Nov 1, 20241 min read

Problem description & analysis: Here below is an annual and quarterly sales data table: Task: In this table, column A is ordered and has duplicate...

#87 — Merge Data of The Same Group

#86 — Calculate Using Adjacent Row/Interval When Data of The Same Group Is Discontinuous (LRR/YOY in The Case of Missing Data)

Oct 31, 20241 min read

Problem description & analysis: Here below is an annual and quarterly sales data table: Task: In this table, the data for the first quarter of 2020...

#86 — Calculate Using Adjacent Row/Interval When Data of The Same Group Is Discontinuous (LRR/YOY in The Case of Missing Data)