Hello !
We have a situation here where several fields of a record need to be transformed into RECORDS.
Like this :
EMPLOYEE_NO;FIELD_A;FIELD_X;ANOTHER_FIELD;
10; 120; 180; 190;
EMPLOYEE_NO; CODE;VALUE
10; 1; 120
10; 2; 180
10; 3; 190
Notice the relationship between the FIELD NAME and the codes :
FIELD_A : 1
FIELD_X : 2
ANOTHER_FIELD : 3
I have no idea of how to LOAD this data.
Would someone else help me out with this ?
Notice that it's not the case of a CROSSTABLE cause the transformation rule is not regular (FIELD_A/etc).
Thanks !