Stack

In this document, you’ll learn how to use the Stack transformation in Astera Dataprep to combine multiple columns into a single column for easier analysis.

Suppose you have a dataset containing patient glucose readings across different times of the day. By applying Stack, you can merge these time-specific columns into one Glucose Level column, with an additional Category column indicating the time of measurement, making the data easier to analyze and visualize.

1. To apply Stack in Astera Dataprep, click on the Transform option in the toolbar and select Stack from the drop-down.

1. Once selected, the Recipe Configuration – Stack panel will open.

• Column Name: Select the column(s) you want to stack.

• Stacking Option: Defines how values and identifiers are combined when stacking columns.

  • Repeat: Repeats identifier or reference values for each stacked entry.

  • Stack: Merges values without repeating identifiers.

• Category: Specify the category column to label each stacked group.

1. Once done, click Apply.

2. Now, in the grid, you can see that all glucose measurements are combined into a single column, with a corresponding category indicating the time of day they were taken.