Tag Archives: Add Conditional Column

Situation: We are given a simple table on the left. We need to add three additional columns based on the prefix of the StoreID, and the sales values. The table on the right is the expected outcome. And here’s the … Continue reading →