Procedure
- Double-click tJavaRow to open its Basic settings view.
- Click Sync columns to make sure that the schema is correctly retrieved from the preceding component.
-
In the Code field, enter the following code to display
the data extracted from the specific Excel cells.
int seq=Numeric.sequence("s1",2,1); if (seq == 4) { context.a4 = input_row.lastname; } if (seq == 1) { context.b1 = input_row.firstname; } if (seq == 9) { context.c9 = input_row.city; } if (seq == 6) { context.d6 = input_row.zip; }Note: In the Code field, input_row corresponds to the links to and from tJavaRow. - Double-click tLogRow to open its Basic settings view and select the Table (print values in cells of a table) option for better display effect.