on 03-06-2009 7:12 PM
Hello,
I have an xi scenerio where I am going from IDOC to flat file. I have an issue where a segment can occur multiple times and I want to take the last segment of that multiple occuring segment as my record to flatfile.
for example
EDI_DC
EMPLOYEE
EMPLOYEE_PERSONAL_INFO
EMPLOYEE_ADDRESS_INFO
EMPLOYEE_ADDRESS_INFO
EMPLOYEE_ADDRESS_INFO
EMPLOYEE_BENEFIT_INFO
.....
in the above example, i want to take the last occurance of the EMPLOYEE_ADDRESS_INFO in my message mapping without any logic around dates or statuses.
is there an easy way to do this?
thank you
use this logic;
source -> COUNT-
|--- EqualsS -> pass the source to target
source -> INDEX -
the logic is count function will give you the number of occurrences and Index will return the current occurrence.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This worked perfectly thank you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.