topic Re: How to handle CHAR data type in QlikView in QlikView

How to handle CHAR data type in QlikView

bimala0507 — Mon, 15 Jun 2015 08:31:57 GMT

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

Re: How to handle CHAR data type in QlikView

MK_QSL — Mon, 15 Jun 2015 08:33:10 GMT

Use

Text(YourFieldName) as YourFieldName

Re: How to handle CHAR data type in QlikView

MayilVahanan — Mon, 15 Jun 2015 08:42:58 GMT

Try like this

Load *, text(fieldName) as TextField;

Sql Select * from tablename;

Re: How to handle CHAR data type in QlikView

bimala0507 — Mon, 15 Jun 2015 08:53:53 GMT

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

Kind Regards,

Bimala

Re: How to handle CHAR data type in QlikView

bimala0507 — Mon, 15 Jun 2015 08:57:40 GMT

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.

Re: How to handle CHAR data type in QlikView

Anvesh — Mon, 15 Jun 2015 09:25:01 GMT

Hi Mishra,

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

Regards

Anvesh