load script

[hcabrera]

Hi,

I have a table that stores the code item IXKITL, code item necessary to manufacture IXLITM, quantity and cost, in some cases each IXLITM is an IXKITL in the same table with their respective IXLITM, it is required to be able to visualize in the same pivot table the different levels that I can have every IXKITL, attached example, how can i do this in the load script ??

thanks for your help

Henry C.

[hcabrera]

Better explained:

Table                                                       Pivot Table

IXKITL,  IXLITM                                   IXKITL, IXLITM,   IXKITL1, IXLITM1 .... IXKITLN

A            a                                                 A          a               1             I

A            b                                                 A          a               1            II

A            c                                                 A          a               1            III

a            1                                                 A          a               2

a            2                                                 A          a               3

a            3                                                 A          b

1            I                                                  A          c

1            II                                               

1            III

thanks for help !!