Text Becoming Numbers

[ThePeterK]

Hey Folks,

I'm changing a sort order in the data manager. When I load the data, the table has the correct values and the correct order. When I try to use it in the app, it converts the value to a number (e.g. 1, 2). Has anyone seen this before? Is there a fix?

[vinieme12 · Accepted solution]

In the "Data Load Editor"

Modify the load script to force the field as text USING TEXT() FUNCTION 

Example load script will be as below

tablename:

Load 

Field1

,TEXT(field2) as field2

,

From xyzfile.xlsx

[ThePeterK]

Any way to do that with a load *?

[draghici1109]

as far as I am aware, no. You has to apply the text() function to every field.