Breaking down an aggregate

[mattlukoff]

Hello,

I have data like this:

Date	Metric	Count
01/01/2018	View	14
02/01/2018	View	4
03/01/2018	View	1

which is an aggregated count of Metric by Day. However I actually want to transform this data to show a line for each Metric. i.e. in record # 1, the Metric has a count of 14 so I want to see that row of data 14 times. 

Any suggestions how I could do this in Alteryx?

[vkarthik21 · Accepted solution]

All you need to use is 'Generate Rows' transformation with the 'Condition Expression' set as RowCount <= [Count] as shown below -

You can then use select to chose only the columns you need