topic Re: conversion from number to string in QlikView

conversion from number to string

QSense — Wed, 27 Aug 2014 19:30:44 GMT

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

Re: conversion from number to string

MarcoWedel — Wed, 27 Aug 2014 21:25:19 GMT

can you post a sample app?

thanks

regards

Marco

Re: conversion from number to string

Wed, 27 Aug 2014 21:31:59 GMT

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.