Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Generating rows of data based on count in column

I have data on two different granularity levels: 1. One result per one row, for example Category   Result Cat1          1 Cat1          3 Cat1          5 Cat2          3 Cat2          4 2. Data fo...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    I see. So back in your second table, you can add a custom column with the following code:

    { 1..[Count]}

    That will produce a list starting at 1 to whatever the # in count is. You can go ahead and expand that out

    Append with table one, and you get this table 

     

    Only interested in Category, Result and Average, so can remove all the other columns. 

     

    Then just merge the Result and Average columns and you the following table:

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I see. So back in your second table, you can add a custom column with the following code:

{ 1..[Count]}

That will produce a list starting at 1 to whatever the # in count is. You can go ahead and expand that out

Append with table one, and you get this table 

 

Only interested in Category, Result and Average, so can remove all the other columns. 

 

Then just merge the Result and Average columns and you the following table:

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Perfect, thank you!