topic Techniques to load data from a field with multiple data types in QlikView https://community.qlik.com/t5/QlikView/Techniques-to-load-data-from-a-field-with-multiple-data-types/m-p/280489#M104388 <HTML><HEAD></HEAD><BODY><P>I am trying to buid a load script to pull data from a change tracking table in our TMS system.&nbsp; The field tracks the original value of a field before it was changed.&nbsp; The field is a varchar in the database and it can contain integer values (weights), date values (ship date), alphanumeric (store codes), and char data all within the same source field from the table. </P><P></P><P>Is there a way using an IF THEN statement to determine a data type as X and pull it as X while another is Y and is pulled as Y?</P><P></P><P>I have tried a couple of statements which have got me closer, but the end result is QV pulling any numeric values and converting them to a date.</P><P></P><P>Thanks!</P></BODY></HTML> Thu, 27 Oct 2011 20:11:09 GMT 2011-10-27T20:11:09Z Techniques to load data from a field with multiple data types https://community.qlik.com/t5/QlikView/Techniques-to-load-data-from-a-field-with-multiple-data-types/m-p/280489#M104388 <HTML><HEAD></HEAD><BODY><P>I am trying to buid a load script to pull data from a change tracking table in our TMS system.&nbsp; The field tracks the original value of a field before it was changed.&nbsp; The field is a varchar in the database and it can contain integer values (weights), date values (ship date), alphanumeric (store codes), and char data all within the same source field from the table. </P><P></P><P>Is there a way using an IF THEN statement to determine a data type as X and pull it as X while another is Y and is pulled as Y?</P><P></P><P>I have tried a couple of statements which have got me closer, but the end result is QV pulling any numeric values and converting them to a date.</P><P></P><P>Thanks!</P></BODY></HTML> Thu, 27 Oct 2011 20:11:09 GMT https://community.qlik.com/t5/QlikView/Techniques-to-load-data-from-a-field-with-multiple-data-types/m-p/280489#M104388 2011-10-27T20:11:09Z