topic Re: convert to text in QlikView

convert to text

Anonymous — Fri, 23 Oct 2015 16:48:42 GMT

This is my load:

REQUIREMENT:

LOAD ROWID,

WORKORDER_TYPE,

WORKORDER_BASE_ID,

WORKORDER_LOT_ID,

WORKORDER_SPLIT_ID,

WORKORDER_SUB_ID,

OPERATION_SEQ_NO,

PIECE_NO,

TYPE,

BITS,

BITS_LENGTH;

SQL SELECT *

FROM .dbo.REQUIREMENT;

There is an i next to the bits not sure what that means:

This is in the sql select window.

This is what is loaded when I don't make any changes:

What should be in the bits column is below:

it should read "WTG DATA" or something like that.

I'm not sure how to make this conversion to a legible text line.

Any help would be much appreciated. Thank you!

Re: convert to text

Anonymous — Fri, 23 Oct 2015 17:00:11 GMT

What is the data type of that field?

Re: convert to text

Anonymous — Fri, 23 Oct 2015 17:03:25 GMT

The book says the column type is Longvar.

Re: convert to text

Anonymous — Fri, 23 Oct 2015 17:07:42 GMT

I'm guessing this is actually a BLOB/CLOB then. I would cast/convert it to varchar2 on the database side before bringing it into QV and see what happens.

Re: convert to text

Anonymous — Fri, 23 Oct 2015 17:09:26 GMT

Thank you.