Hello,
My problem is structure resultset mapping to rows (header - details).
If details is ("emplty" o "null" o "") not register.
If details not is ("emplty" o "null" o "") register.
Structure SOURCE.
Resulset
ROW (0..outbound)
-ID (Identificador)
-HEADER
-A_ID_ITEM1
-A_NAME1
-B_ID_ITEM2
-B_NAME2
Example
Title ID ;HEADER;A_ID_ITEM1;A_NAME1;B_ID_ITEM2;B_NAME2
row1 ID1 ;xxxx ; ; ;1 ;A
row2 ID1 ;xxxx ;2 ;B ; ;
row3 ID2 ;yyyy ; ; ;1 ;X
row4 ID2 ;yyyy ; ; ;2 ;Y
row5 ID2 ;yyyy ;3 ;Z ; ;
Structure TARGET
ROW (0..outbound)
HEADER (1..1)
-HEADER
ITEMS1 (0..outbound)
-A_ID_ITEM1
-A_NAME1
ITEMS2 (0..outbound)
-B_ID_ITEM2
-B_NAME2
Example.
ROW (1)
HEADER (1)
ITEMS2(1)
B_ID_ITEM2(1)
B_NAME2(A)
ITEMS2(2)
A_ID_ITEM1(2)
A_NAME1(B)
ROW (2)
HEADER (1)
ITEMS2(1)
B_ID_ITEM2(1)
B_NAME2(X)
ITEMS2(2)
B_ID_ITEM2(2)
B_NAME2(Y)
ITEMS2(2)
A_ID_ITEM1(3)
A_NAME1(Z)
Atte. Claudio Leó