I need to create a new table with multiple lines using data from a previous table as a parameter.
For example
_______________________
| nome | quantidade |
|--------|------------|
| xyz | 2 |
| abc | 1 |
-----------------------
Expected
__________________
| nome | número|
|--------|-------|
| xyz | 1 |
| xyz | 2 |
| abc | 1 |
------------------
In the example I use the quantity data as a parameter for creating N rows according to the quantity, and is populated in the other table with N rows of quantity and filling the column number from 1 to N.