Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Below is my input data, in which I have main field PSPNR which is the main number of rows. In this data LEFT, Right, UP and DOWN are the position of the main number. Now I wants to create the hierarchy from this input.
Input Data:
PSPNR | POSID | OBJNR | LEFT | RIGHT | UP | DOWN |
209 | I0006 | PR00000209 | 0 | 0 | 0 | 210 |
210 | I0006 1 | PR00000210 | 0 | 396 | 209 | 0 |
396 | I0006 2 | PR00000396 | 210 | 477 | 209 | 0 |
477 | I0006 3 | PR00000477 | 396 | 0 | 209 | 0 |
Output Data 1:
POSID1 | POSID3 | OBJNR |
I0006 | 1 | PR00000210 |
| 2 | PR00000396 |
| 3 | PR00000477 |
Output Data 2:
POSID1 | POSID3 | OBJNR |
I0006 |
| PR00000209 |
1 | PR00000210 | |
2 | PR00000396 | |
3 | PR00000477 |
Other Big Example:
Input:
PSPNR | POSID | OBJNR | LEFT | RIGHT | UP | DOWN |
1757 | I0016 | PR00001757 | 0 | 0 | 0 | 1758 |
1758 | I0016 | PR00001758 | 0 | 2056 | 1757 | 1759 |
1759 | I0016 | PR00001759 | 0 | 1760 | 1758 | 0 |
1760 | I0016 | PR00001760 | 1759 | 1761 | 1758 | 0 |
1761 | I0016 | PR00001761 | 1760 | 1762 | 1758 | 0 |
1762 | I0016 | PR00001762 | 1761 | 0 | 1758 | 0 |
2056 | I0016 | PR00002056 | 1758 | 2058 | 1757 | 2057 |
2057 | I0016 | PR00002057 | 0 | 2253 | 2056 | 0 |
2058 | I0016 | PR00002058 | 2056 | 2128 | 1757 | 2059 |
2059 | I0016 | PR00002059 | 0 | 3368 | 2058 | 0 |
2128 | I0016 | PR00002128 | 2058 | 2129 | 1757 | 0 |
2129 | I0016 | PR00002129 | 2128 | 2130 | 1757 | 0 |
2130 | I0016 | PR00002130 | 2129 | 2816 | 1757 | 0 |
2253 | I0016 | PR00002253 | 2057 | 2264 | 2056 | 0 |
2264 | I0016 | PR00002264 | 2253 | 2265 | 2056 | 0 |
2265 | I0016 | PR00002265 | 2264 | 2266 | 2056 | 0 |
2266 | I0016 | PR00002266 | 2265 | 2601 | 2056 | 0 |
2601 | I0016 | PR00002601 | 2266 | 2812 | 2056 | 0 |
2812 | I0016 | PR00002812 | 2601 | 2813 | 2056 | 0 |
2813 | I0016 | PR00002813 | 2812 | 3772 | 2056 | 0 |
2816 | I0016 | PR00002816 | 2130 | 2819 | 1757 | 2817 |
2817 | I0016 | PR00002817 | 0 | 2818 | 2816 | 0 |
2818 | I0016 | PR00002818 | 2817 | 2881 | 2816 | 0 |
2819 | I0016 | PR00002819 | 2816 | 2878 | 1757 | 2820 |
2820 | I0016 | PR00002820 | 0 | 2821 | 2819 | 0 |
2821 | I0016 | PR00002821 | 2820 | 2880 | 2819 | 0 |
2878 | I0016 | PR00002878 | 2819 | 0 | 1757 | 2879 |
2879 | I0016 | PR00002879 | 0 | 0 | 2878 | 0 |
2880 | I0016 | PR00002880 | 2821 | 3332 | 2819 | 0 |
2881 | I0016 | PR00002881 | 2818 | 3159 | 2816 | 0 |
3159 | I0016 | PR00003159 | 2881 | 3328 | 2816 | 0 |
3328 | I0016 | PR00003328 | 3159 | 3329 | 2816 | 0 |
3329 | I0016 | PR00003329 | 3328 | 3330 | 2816 | 0 |
3330 | I0016 | PR00003330 | 3329 | 3331 | 2816 | 0 |
3331 | I0016 | PR00003331 | 3330 | 3394 | 2816 | 0 |
3332 | I0016 | PR00003332 | 2880 | 3367 | 2819 | 0 |
3367 | I0016 | PR00003367 | 3332 | 3782 | 2819 | 0 |
3368 | I0016 | PR00003368 | 2059 | 3614 | 2058 | 0 |
3394 | I0016 | PR00003394 | 3331 | 0 | 2816 | 0 |
3614 | I0016 | PR00003614 | 3368 | 0 | 2058 | 0 |
3772 | I0016 | PR00003772 | 2813 | 3773 | 2056 | 0 |
3773 | I0016 | PR00003773 | 3772 | 3774 | 2056 | 0 |
3774 | I0016 | PR00003774 | 3773 | 3807 | 2056 | 0 |
3782 | I0016 | PR00003782 | 3367 | 3783 | 2819 | 0 |
3783 | I0016 | PR00003783 | 3782 | 3784 | 2819 | 0 |
3784 | I0016 | PR00003784 | 3783 | 0 | 2819 | 0 |
3807 | I0016 | PR00003807 | 3774 | 0 | 2056 | 0 |
Output1:
POSID1 | POSID4 | POSID3 | OBJNR |
I0016 |
|
| PR00001757 |
1 | 1 | PR00001758 | |
| PR00001759 | ||
| PR00001760 | ||
| PR00001761 | ||
| PR00001762 | ||
2 |
|
| |
3 |
|
| |
4 |
|
| |
5 |
|
| |
6 |
|
| |
7 |
|
| |
8 |
|
| |
9 |
|
|
Output2:
POSID1 | POSID4 | POSID3 | OBJNR |
I0016 | 1 | 1.1 | PR00001759 |
1.2 | PR00001760 | ||
1.3 | PR00001761 | ||
1.4 | PR00001762 | ||
2 |
|
| |
3 |
|
| |
4 |
|
| |
5 |
|
| |
6 |
|
| |
7 |
|
| |
8 |
|
| |
9 |
|
|