ODBC Data Load - field containing numeric and alphanumeric data
I have an ODBC connection between Smartsheet and Qlikview. There is one column of data that I am unable to completely bring into Qlikview successfully. The column contains primarily numeric data but has a few alphanumeric entries. The alphanumeric entries will not come into Qlikview; they show as blanks when I preview the data.
After reading through some other questions/answers, I believe I need a preceding load statement to classify this field as text, but I am uncertain as to the proper structure of the load statement/script, and I am uncertain as to where to place the load statement.
These are the first few lines in the script. Can anyone tell me how to write the line to get the "1 CPT/HCPCS Reported" field to come into Qlikview as text? Also, where in the statement would it need to be placed?
ODBC CONNECT TO SmartSheetConnector; SQL SELECT "# of ICD-10 Codes Reported on Claim", "Provider Name (Autopopulates)", "Audit Project", "1 CPT/HCPCS Reported",
Hello, Your load statement processed successfully without errors, but it didn't allow the alphanumeric values to come into Qlikview from Smartsheet. I did more research, and now I believe the issue lies with Smartsheet's Live Data Connector Default Settings . There are advanced options that lie within the connection properties with options to always return text, use majority rule, and use entirety rule. I'm going to ask our administrator to check our setting. It seems the entirety rule might correct this.