load script with Hierarchy()

[hcabrera]

Hi,

I have a table Data need load script for show pivot table in the example:

Table   Data                                                 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 your help !!

Henry C.

[Anonymous]

More info on your needs and logic please!

[hcabrera]

Hi Aron, thanks for answer,  I need use Hierarchy () or HierarchyBelongTo()  function for this table

TABLE
IXKIT	IXITM	IXLITM
57398	57520	01GENCAL0008
57407	57398	04GENCAL0005
57407	99909	01GENESC0001
57407	57404	04GENARC0003
57407	57402	05GENARC0001
57408	57407	04GENCRU0001
73306	57408	04GENCRU0002
73306	57644	01GENCAL0009
73306	57403	01GENPUZ0001
73306	99048	01GENYES0005

Show as:

RESULT
IXKIT	IXITM	IXITML	IXITM1	IXITM2	IXITM3
73306	57408	04GENCRU0002	57407	57398	57520
73306	57408	04GENCRU0002	57407	99909
73306	57408	04GENCRU0002	57407	57404
73306	57408	04GENCRU0002	57407	57402
73306	57644	01GENCAL0009
73306	57403	01GENPUZ0001
73306	99048	01GENYES0005

thanks,

Henry C.