How to handle CHAR data type in QlikView

[bimala0507]

Hi Experts:

I am currently facing a issue with CHAR data type. The source system is SYBASE and data type is CHAR. The field stores information such as 01,02,03, 01A,02B,03B etc. Now when I bring that information into Qlikview, few data is coming as 01,02,03 however  for few it converts it into 1,2,3,4 etc. I thought TEXT(field) would solve the issue, but that is not the case. It is just a direct load from the source table. Can anyone advice, what should I do from my end in order to bring the data as it is. Since the field can also store 1,2,3,4,5 along with 01,02,03. I need to bring as it is entered at the source system.

Appreciate a suggestion  to handle this data issue.

Kind Regards,

Bimala 

[MK_QSL]

Use

Text(YourFieldName) as YourFieldName

[MayilVahanan]

Hi

Try like this

Load *, text(fieldName) as TextField;

Sql Select * from tablename;

[bimala0507]

I have already used Text command. It's not helpful here.

Kind Regards,

Bimala

[bimala0507]

Text command is not being helpful here. While transferring the data itself for few cases (Not all cases), it is truncating 0 from the field and showing only the number.

[Anvesh]

Hi Mishra,

Follow this thread Leading 0 in Text field Qlikview transforms data incorrectly , hope it might be helpful to you

Regards

Anvesh