2 Replies Latest reply: May 1, 2014 5:24 PM by Clever Anjos RSS

    How to ensure QV reads the same field format?

    Shelley Smith

      I have a field from our company data warehouse called "Site."  In the field are characters like "1001" and "2001" but I am not sure if they are text or numeric.  In one of the tables I am loading in the script, I have to manually add a field called "Site" and need to ensure it = 1001.  When I bring the data into the app, it seems like 1001 in my homemade field does not equal 1001 from the field in the data warehouse.  I'm wondering if these are both different fields, like one is text and one numeric.  How do I ensure it reads them both as numeric or both as text?  This is probably and easy fix, I just don't know the correct functions.  Thanks!