Hello experts,
I've data coming into the SAP PI system containing a flat structure.
There is a field, EAN, which can be the same all the time. But when it changes, a new segment must be created in the target structure.
flat source structure
row 1 ...541449011000110968...
row 2 ...541449011000110968...
row 3 ...541449011000110968...
row 4 ...541449020000612242...
row 5 ...541449020000612242...
row 6 ...541449020706752129...
row 7 ...541449020706752129...
row 8 ...541449020706752129...
must result in
3 segments in the target XML
1. with EAN 541449011000110968
2. with EAN 541449020000612242
3. with EAN 541449020706752129
I tried with node function SplitByValue, but it does not work.
Please advice.
Thanks a lot
Dimitri