Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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]
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]