Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
More info on your needs and logic please!
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.