Text loading as numbers

[#1]

Hi,

I have a table in access database with column cameraname and this column contains character(text) adat. When I am loading this table the character data is loading as numbers. can anyone let me know please what is this strange behaviour.

Thanks.

[antoniotiman]

I resolve the same problem with Load Resident statement in the script that transfrorms the fields.

[#3]

Sorry I don't have access to open the tables from front end database. Only I can able to see in qvw. Please find attached some sample. So, instaed of these names it is showing numbers.

[Peter_Cammaert]

The problem is not in the data. The problem is either in your script or in the way you visualize the data. I'm guessing it's the former.

Can you post part of the script where you load the table with cameranames?

[Peter_Cammaert]

Something else: is this Access database composed of different files with links between the master and the other files? Or does all the data reside in a single file?

[#6]

ok I will explain.

Actually I was loading the data from access database table to qvd. Before storing to qvd I just checked the cameranames and observed instaed of names it is showing numbers.

TblCamera:
LOAD ID,
   
    cameraname,
 

SQL SELECT *
FROM tblCamera;

STORE TblCamera INTO c:\Qlikview\TblCamera.qvd;

DROP TABLE TblCamera;

[Peter_Cammaert]

Could it be that the ID ended up in the cameraname field?

If you execute this script part a second time and dump the table in a QVD again, does that fix the cameraname values?

If you open the script editor with the above script, and you press the SELECT... button, navigate to the Access database and open the table selection dialog. Select the tblCamera table and go to the tab Preview. What's in column cameraname?

[#8]

you are right. In the preview pane it is showing numbers under cameraname. How can I resolve this? Please let me know

EDIT: the Data_Type for cameraname is SQL_WVARCHAR(-9)

[#9]

try this

Text(FieldName) as FieldName

[Peter_Cammaert]

OK then there are no cameranames in that particular field.

Maybe the cameranames field that you are trying to load contains just an index number that refers to another (possibly external) table with camera information? But I'm only guessing since we do not have any information about either your QVW or your DB structure...

Edit: Best thing you can do to resolve this mystery is open your DB in MS Access and inspect the different tables and rows. That I didn't think of this before

[sundarakumar]

Hi Amelia

I just came across the same issue.

Problem: the particular field in the access DB is being created as a look up i.e. it can only accommodate the predefined values. this is a problem with DB field creation. The values are just a reference in this case.

Resolution: this is more of a work around. Best way is to correct it in DB. You can see the required text file in DB and u have a id column in the same table. extract these two columns from the access DB to an excel. U have the same ID and the numeric version of the text field in the application. get the ID and the numeric values of the text in a table box in your application and export it to an excel.

now u have 2 excel with {ID, Text} and {ID,TEXT(in numbers)}. u can link them and find the number version of the text column and join it to your application as new field.

I know its too late. It may help others though

Regards,

Sundar