Help with Data Load - Transform fields into records

[#1]

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 !