i got a Function how give out this String as a unlimited String sperated by ; and ending with line feed. I used this Code to Break out the strings in Multipli rows looks like these:
I believe it's not possible to "create" rows from tJavaRow, because the code you write there only affects the "main" part of component execution. So any loop you define there will iterate over a single row and that's why you're getting only the last record of your input data. It is iterating over all the records on the input, but it only outputs data after completing the loop and then there's only the last values recovered during loop.
However, you can achieve this using tJavaFlex by spliting your code on Start, Main and End sections:
String input = input1; // Assuming your input string is available in a field named "inputString"
String[] lines = input.split("\\n"); // Split the input into individual lines
for (String line : lines) { //just the loop header here to create rows for each record on the input data
Main code:
//now we can split the columns and output them, remember to replace the output_row by the corresponding output row name connecting tJavaFlex to next component
String[] fields = line.split(";"); // Split each line into fields based on the semicolon separator
String field1 = fields[0]; // Retrieve the first field
row1.newColumn = fields[0];
String field2 = fields[1]; // Retrieve the second field
row1.newColumn1 = fields[1];
String field3 = fields[2]; // Retrieve the third field
row1.newColumn2 = fields[2];
String field4 = fields[3]; // Retrieve the fourth field
row1.newColumn3 = fields[3];
String field5 = fields[4]; // Retrieve the fifth field
row1.newColumn4 = fields[4];
// Perform further processing or output the parsed fields as needed
I believe it's not possible to "create" rows from tJavaRow, because the code you write there only affects the "main" part of component execution. So any loop you define there will iterate over a single row and that's why you're getting only the last record of your input data. It is iterating over all the records on the input, but it only outputs data after completing the loop and then there's only the last values recovered during loop.
However, you can achieve this using tJavaFlex by spliting your code on Start, Main and End sections:
String input = input1; // Assuming your input string is available in a field named "inputString"
String[] lines = input.split("\\n"); // Split the input into individual lines
for (String line : lines) { //just the loop header here to create rows for each record on the input data
Main code:
//now we can split the columns and output them, remember to replace the output_row by the corresponding output row name connecting tJavaFlex to next component
String[] fields = line.split(";"); // Split each line into fields based on the semicolon separator
String field1 = fields[0]; // Retrieve the first field
row1.newColumn = fields[0];
String field2 = fields[1]; // Retrieve the second field
row1.newColumn1 = fields[1];
String field3 = fields[2]; // Retrieve the third field
row1.newColumn2 = fields[2];
String field4 = fields[3]; // Retrieve the fourth field
row1.newColumn3 = fields[3];
String field5 = fields[4]; // Retrieve the fifth field
row1.newColumn4 = fields[4];
// Perform further processing or output the parsed fields as needed
