conversion from number to string

[QSense]

Hello everyone;

I have a problem .It is about a field.In my database the field is string but when ı loaded into qw

As if ıt behaves like a number column.

For instance I have a value 0123 and when ı use it for join ıt brings two value for this '0123'

since in the other table ıt has two value 123 and 0123.

I used text function but it does not work for me

I hope explained my problem explicitly

Thanks

[MarcoWedel]

can you post a sample app?

thanks

regards

Marco

[#3]

Hi,

Sometimes it happens but just specify this field like a text with text() function into script, something like this:

MyData:

LOAD

     Field1

     Field2,

     FieldN,

     Text(MyProblemField) as MyNewNameField

From MySource;

If your source is SQL maybe your script look like this:

MyData:

LOAD

     Field1

     Field2,

     FieldN,

     Text(MyProblemField) as MyNewNameField;

SQL

Select * From MyTable;

Best regards.