How to convert this table

[#1]

Hi All,

I have one table:

load * Inline

[OrderId,ChargeTimes

1,3

2,2

];

The order 1 was charged 3 times and order 2 was charged 2 times.

What I want is to show them seperated.

ChargeSequence, OrderId

1,1

2,1

3,1

1,2

2,2

How can I do it?

Thanks.

[hic]

Load

     OrderID,

     ChargeTimes,

     IterNo() as ChargeSequence

     From ...

          While IterNo() <= ChargeTimes;

HIC

[#3]

Hi !!!

PFA

[#4]

HI,

PFA

Hope it helps you