topic Help with Data Load - Transform fields into records in QlikView https://community.qlik.com/t5/QlikView/Help-with-Data-Load-Transform-fields-into-records/m-p/168913#M39899 <HTML><HEAD></HEAD><BODY><P>Hello !</P><P>We have a situation here where several fields of a record need to be transformed into RECORDS.</P><P>Like this :</P><P><PRE></PRE></P><P>EMPLOYEE_NO;FIELD_A;FIELD_X;ANOTHER_FIELD;<BR /> 10; 120; 180; 190;<BR /><BR />EMPLOYEE_NO; CODE;VALUE<BR /> 10; 1; 120<BR /> 10; 2; 180<BR /> 10; 3; 190<BR /></P><P>Notice the relationship between the FIELD NAME and the codes :</P><P><PRE></PRE></P><P>FIELD_A : 1</P><P>FIELD_X : 2</P><P>ANOTHER_FIELD : 3<BR /></P><P>I have no idea of how to LOAD this data.</P><P>Would someone else help me out with this ?</P><P>Notice that it's not the case of a CROSSTABLE cause the transformation rule is not regular (FIELD_A/etc).</P><P>Thanks !</P><P></P><P></P><P></P></BODY></HTML> Mon, 30 Nov 2009 18:34:46 GMT 2009-11-30T18:34:46Z Help with Data Load - Transform fields into records https://community.qlik.com/t5/QlikView/Help-with-Data-Load-Transform-fields-into-records/m-p/168913#M39899 <HTML><HEAD></HEAD><BODY><P>Hello !</P><P>We have a situation here where several fields of a record need to be transformed into RECORDS.</P><P>Like this :</P><P><PRE></PRE></P><P>EMPLOYEE_NO;FIELD_A;FIELD_X;ANOTHER_FIELD;<BR /> 10; 120; 180; 190;<BR /><BR />EMPLOYEE_NO; CODE;VALUE<BR /> 10; 1; 120<BR /> 10; 2; 180<BR /> 10; 3; 190<BR /></P><P>Notice the relationship between the FIELD NAME and the codes :</P><P><PRE></PRE></P><P>FIELD_A : 1</P><P>FIELD_X : 2</P><P>ANOTHER_FIELD : 3<BR /></P><P>I have no idea of how to LOAD this data.</P><P>Would someone else help me out with this ?</P><P>Notice that it's not the case of a CROSSTABLE cause the transformation rule is not regular (FIELD_A/etc).</P><P>Thanks !</P><P></P><P></P><P></P></BODY></HTML> Mon, 30 Nov 2009 18:34:46 GMT https://community.qlik.com/t5/QlikView/Help-with-Data-Load-Transform-fields-into-records/m-p/168913#M39899 2009-11-30T18:34:46Z