Adding the Loop and Iterators
To add the necessary loop and iterators for the tutorial
1. Select the Loop Link Mode.
2. Click in the operation handle next to the foo:customer column of in and connect it to customer [ ] .
3. Save your transform.
4. Double-click loop.
5. Click the green plus icon to add a Loop Iterator.
6. Click the green plus icon one more time.
7. Click Close.
8. Save your transform.
9. Validate and or create links between the following From and To columns.
From in | To loop |
foo.Customer | foo.customer |
foo.orders | source |
foo.orderitems | source2 |
10. Validate and or create links between the following From and To columns.
From loop | To out |
customer | customer |
foo.customerID | customer : customerid |
foo.customerID | order : customerid |
foo:customerName | customer : customername |
orders | order |
foo:orderID | order : orderid |
foo:orderID | orderitem : orderid |
foo.orderSubTotal | order : ordersubtotal |
orderitems | orderitem |
foo:orderItemID | orderitem : orderitemid |
foo:orderItemName | orderitem : orderitemname |
foo:orderItemDescription | orderitem : orderitemdescription |
11. Save your transform.