Looping logic

Question

Hi,

Below is the loop requirement .

Based on id and parent id , column new_pid need to be calculated . id can go upto thousands .

id code parent id new pid 1V01002V021V013V032V01,V024V045V03,V025V053V01

Any help is appreciated. Thanks.

Qiu · Answer

@Nandakishore 
I think we can add one Sorting tool to resolve this issue.

0204-praneshsapmm-f1.yxzp

Nandakishore · Answer

Hi @Qiu  ,

The solution works beautifully for now . But the only challenge is the how the values are sorted in new_pid .

As the iterations increase at times , the sorting is not correct .

I mean first the values of lowest parentid need to be available followed by the later one in column new_pid . can you help .

Thanks .

Qiu · Answer

I think we can use this macro to generaate the hierarchy first then the rest will be easy,

0204-praneshsapmm.yxzp