topic Generate a number sequence in a single Cell in App Development

Generate a number sequence in a single Cell

luke1986 — Fri, 14 Dec 2018 08:07:48 GMT

Hello Folks,

This is a trickey one, my Sample Data looks like this:

ID	From-To	Sequence
1	10-70	10
2	20-50	10

The Output should look like this:

ID	Output
1	10,20,30,40,50,60,70
2	20,30,40,50

Has any one a solution?

Thanks

Re: Generate a number sequence in a single Cell

tresB — Fri, 14 Dec 2018 10:29:34 GMT

And tricky sometimes draws more attention! Try like:

Load
	ID,
	Concat(Output, ',') as Output
Group By ID;	
Load
	ID,
	From+Sequence*(IterNo()-1) as Output
While From+Sequence*(IterNo()-1) <=To;	

Load *,
	SubField([From-To], '-',1) as From,
	SubField([From-To], '-',2) as To
Inline [
ID,	From-To,	Sequence
1,	10-70,	10
2,	20-50,	10]

Re: Generate a number sequence in a single Cell

luke1986 — Fri, 14 Dec 2018 10:35:54 GMT

Nice One! Thanks!