Create number of rows based on value from column

[Anonymous]

HI all!

I am wondering how to create table like below:

Type	Number
A	1
A	2
B	1
B	2
B	3

‌

when we have table like below:

TYpe	Number
A	2
B	3

Many thanks

[antoniotiman · Accepted solution]

Hi Thomas,

maybe

Load *,IterNo() as CountID Inline [
ID,Value
A,3
B,4
C,3
D,5
]
While IterNo() <= Value;

Regards,

Antonio

[Anonymous]

‌Exactly! Thanks