topic Load field and change data in QlikView https://community.qlik.com/t5/QlikView/Load-field-and-change-data/m-p/461125#M172138 <HTML><HEAD></HEAD><BODY><P>I have a database with a field (sex) consisting of two characters M or F (male and female).</P><P>In the load I´d like to change the F to W, - </P><P>is it possible to make somtheing like</P><P></P><P>LOAD [sex],</P><P>if ([sex]=F), M) as sexA</P><P></P><P>Or maybe a better solution??????</P></BODY></HTML> Mon, 29 Oct 2012 09:02:31 GMT 2012-10-29T09:02:31Z Load field and change data https://community.qlik.com/t5/QlikView/Load-field-and-change-data/m-p/461125#M172138 <HTML><HEAD></HEAD><BODY><P>I have a database with a field (sex) consisting of two characters M or F (male and female).</P><P>In the load I´d like to change the F to W, - </P><P>is it possible to make somtheing like</P><P></P><P>LOAD [sex],</P><P>if ([sex]=F), M) as sexA</P><P></P><P>Or maybe a better solution??????</P></BODY></HTML> Mon, 29 Oct 2012 09:02:31 GMT https://community.qlik.com/t5/QlikView/Load-field-and-change-data/m-p/461125#M172138 2012-10-29T09:02:31Z