I got "???? ??????"

[Vasiliy_Beshentsev]

Hello again, everyone!

In one application that was developed not by me i have reload data and got "???? ?????" instead of data.

How to repair it?

[sunny_talwar]

May be add Text() function around your fields while loading

LOAD Text(Field1) as Field1,

           ....

FROM ...

[Vasiliy_Beshentsev]

No reaction

[sunny_talwar]

Is the data from SQL query?

[Vasiliy_Beshentsev]

Yes

[sunny_talwar]

May be add Text() function equivalent of SQL function in the select statement?

[Vasiliy_Beshentsev]

What do you mean? When i execute query in ssms it's absolutely ok. I can't understand what happened that data became ????? ?????

[Anonymous]

If you export the data from Qlik to Excel do you get the right values or still ????

[Vasiliy_Beshentsev]

Still

[sunny_talwar]

See if this thread offer any help:

Multiple Question mark in list box