Resolution:
In current BW, when using Data Format and Parse Data to parse text, repeating elements isn’t supported (Please refer to CR 1-6FLO4Q). Because of this, if in your input text every line contains multiple fields and the count of the fields is uncertain, you can’t parse the text only with Data format and Parse Data activity.

The workaround is to use Data Format resource, Parse Data and Mapper activities together. First use Data Format and Parse Data to parse the text into the xml where every element represents one line of the text. Then use Mapper activity and tib:tokenize-allow-empty XSLT function to tokenize every line and get sub-elements for each field in the lines.

The demonstration project has been attached for the reference, where the test_WrongProcess process shows the problem described in CR 1-6FLO4Q; process test_Solution shows the workaround.

How to parse repeating elements with Data Format resource, Parse Data and Mapper activities