Scenario is JDBC to File
Pick up a records from two tables.
1st table is Header table and 2nd table is Details table.
Both tables are having Bill_NO
2nd table also contains Line_Item_No
Through SQL query I am picking up 3 records each time.
Problem I am facing in Mapping
for 1st record I have created Target Header segment and under header produced details segment having Line_Item_No
for 2nd record also I have created separate Header segment and under header produced details segment having Line_Item_No
now 3rd record Bill_No is similar to 2nd record but diff Line_Item_No
now for this I dont want to repeat header I just want to repeat Line_Item_No under previously header segment.
Is this requiremt possible. If yes then which logic i can apply, i am relly confused.
header bill no................................details bill no..line item no 3a1OTHR000684 022 HARISH KUMAR 3a1OTHR000684 2 022 3a1OTHR000686 022 AMIT KUMAR GAUR 3a1OTHR000686 2 022 3a1OTHR000686 022 AMIT KUMAR GAUR 3a1OTHR000686 3 022
022 is organization code