on 12-02-2022 2:12 PM
Hi All,
Could you please explain the below XML iteration rule concept applied in Standard CI-DS task.
Please find the details attached.
Iteration Rule "*" applied on AggregatePackageNo and AggregateMaxPackageNo
Three Input Transforms used in Input (Mapping, AggregateMaxPackageNo and AggregatePackageNo) and mapped to Output XML structure.
Sample Input data from View Design Time Data
Mapping Transform (with filter applied for Package Number "51")
AggregateMaxPackageNo Transform
AggregatePackageNo transform
Sample Output data ("15" records with Package Number "51" are grouped) from View Design Time Data
Here with Iteration Rule (all Records with same Package Number grouped under one XML Node).
As per SAP Help portal "*" is Cross Join
* - Cross operation
Performs a Cartesian product of two or more sources.
When the sources have no parent-child relationship, the behavior is the same as a standard SQL CROSS JOIN.
When the sources have a parent-child relationship, the Cartesian operation provides a mechanism to iterate through all instances of the repeatable elements identified by the source schemas in the operation in the document order.
Could someone explain this XML Iteration Rule behavior.
Hi Yeswanth,
Since you use only two nodes for Iteration, it will only process from those two nodes and Mapping node is mapped as a Child node. You need to connect the Child node with the Parent node, else it won't loop and take the value.
If you want the data from Mapping node also in the output, try including it in the first Iteration rule and check. There is also an option to give the condition to join, pls try that also. Let me know how it goes.
Regards,
Krishna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Krishna,
Mapping node is mapped to CT_PIR_IN and fields are mapped under CT_PIR_IN xml node
Could you please explain how Iteration Rule (all Records with same Package Number grouped under one XML Node and fields mapped under CT_PIR_IN as per group) is applied even though we did not add any condition or perform Join operations.
User | Count |
---|---|
76 | |
8 | |
8 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.