DateTime issue. My results give Text and Numeric in same field? Can't convert to date, only int/num
When I import my date into qlik from a CSV, the field has the tag numeric only. It contains date time data.
I have tried converting in a few ways but I can see that qlik is seeing two different types of data. When I try convert to text, remove spaces and then split into the date format it shows two alignments on the field. So text and numeric?
Has this ever happened to anyone? The CSV is large and am struggling to open it anywhere outside of QlikSense at the moment.