Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
jacobesalas
New Contributor II

convert to text

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.

bits load.PNG

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

bits2.PNG

What should be in the bits column is below:

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

bits.PNG

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

Any help would be much appreciated.  Thank you!

4 Replies
chris_deniziak
Contributor

Re: convert to text

What is the data type of that field?

jacobesalas
New Contributor II

Re: convert to text

The book says the column type is Longvar.

chris_deniziak
Contributor

Re: convert to text

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.

jacobesalas
New Contributor II

Re: convert to text

Thank you. 

Community Browser