I think that I am on good way to find solution and figoured out how this can work.
Namely I did next :
Added a looping functiod with an incoming link from Item, then an outgoing link to each of the elements (Order\OrderNo, Order\CustomerNo, etc). Then for each unique CtrlID, added an Equal functoid and a Value Mapping functoid. The Equal functoid have an incoming link of the Item\CtrlID and a static value. The Value Mapping functoid have an incoming linke of the Equal functiod (this must be first), and then the Item\Value element link. The Value Mapping functoid then map to the Order\OrderNo element on the outgoing schema. This repeat for all outgoing elements that need to map.
Namely this works fine for Order Header when I have only one row but the problem is with the Orders Line when I should to have more than one rows.
When I apply the same solution for the OrderLine part than I got this error message :
The adapter failed to transmit message going to send port “SendPortOrder” with URL “C:\Documents and Settings\Administrator\Desktop\PROJECTS\Solution_4_29-09_11-00\out\%MessageID%.CSV”. It will be retransmitted after the retry interval specified for this Send Port. Details:”Unable to read the stream produced by the pipeline. Details: Cannot find definition for the input: LINE_ID “.
It means that I have more Items with the same CtrlID in input.
Do maybe have idea how this can work with the OrderLines where I have more than one lines.
Once again thanks.