Techniques to load data from a field with multiple data types
I am trying to buid a load script to pull data from a change tracking table in our TMS system. The field tracks the original value of a field before it was changed. 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.
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?
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.
