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?
Solucionado! Ir para Solução.
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