HOTSPOT -
You have a Tableau Prep flow that joins a dataset named Global Indicators to a dataset named Price Indices.
In which step can you transform rows of monthly data into rows of yearly data?
HOTSPOT -
You have a Tableau Prep flow that joins a dataset named Global Indicators to a dataset named Price Indices.
In which step can you transform rows of monthly data into rows of yearly data?
Aggregation can be done with aggregator step(E)
The answer is wrong, you can't aggregate data at the output. To aggregate data, implying you would be doing it before the join, you'd use the summarise/aggregation tool that E. Therefore, the answer should be the Epsilon E.
Aggregation Step (Σ): This is where you can aggregate monthly data into yearly data. During this step, you can configure the aggregation to group by year and apply the necessary aggregations (e.g., sum, average) on your monthly data to produce yearly data.
Aggregation Step (Σ)