I have a FF which has header and lineitem details on same record/line in a flat file. If the header has six line items FF will have six records with same header info with six different values for lineitems. FF has record identifier and fields are separated by “;”.
I created FF schema with record definition (for header) with maxRepeat = unlimited with field definitions and under the same hierarchy created record definition for (line items) with maxRepeat =unlimited with field definitions. My question is how to group data by header.
When I ran the schema with sample FF in results pane it is showing values for the Header only once which is correct, for the lineitems it is not showing the values in the first record:confused: but for showing remaining records…. Am I missing something need suggestions, new to WM.
Here is the sample layout of the FF
INDENTIFIER; A; B; C; D; X1; Y1; Z1;
INDENTIFIER; A; B; C; D; X2; Y2; Z2;
INDENTIFIER; A; B; C; D; X3; Y3; Z3;
INDENTIFIER; A; B; C; D; X4; Y4; Z4;
INDENTIFIER; A; B; C; D; X5; Y5; Z5;
INDENTIFIER; A; B; C; D; X6; Y6; Z6;
Where A, B, C, D are Header fields and X, Y, Z are lineitem fields.
Thanks in advance.