Relevant Scenario(s)

There have been several instances when columns values have to be aggregated in a list of comma separated values. Contrast this to the requirement in this article where we needed to split up a comma separated list in a column into multiple rows.

This kind of aggregation requirement arises when…

Relevant Scenario(s)

When you are accumulating wealth, you will run into the task of aggregating and analyzing the totals, either per period or over an entire span of time.

General Ledger Account Scenario

In the case temporary accounts such as expenses, which is a temporary general ledger account, an accounting firm will…

Simi Talkar

Certified DS Associate (DP-100, DA-100), pursuing Masters in University Of Michigan’s Applied Data Science Program

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store