Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
QlikView at first glance will read as Numeric Format to both your field.
If you want to make sure that you want QlikView to read 1001 as text, use below in your script.
Text(YourFieldName) as YourFieldName
Do you want them numbers or text?
1) Numbers: maybe you have to trim your values while loadind
LOAD
trim(yourfield) as yourfield
2) Text
load
text(yourfield) as yourfield