Qlikview removing data in SELECT statement

[#1]

I have a problem with loading data from one of our databases.

I have a table that contains the following values:

ITEM     BATCH

1090     15 17 80

1090     151780

1090     197815

When I load the data into qlikview like this:

ItemBatches_temp:

SELECT

     ITEM,

     BATCH

FROM

     ITBATABLE;

...I end up with a table containing only this:

ITEM     BATCH

1090     151780

1090     197815

This is a problem since "15 17 80" and "151780" are both unique batches which need to be tracked. I need all the values, but I don't know how to get them both. Anyone run into this before?

When I extract data outside of qlikview with the same SQL it returns with all the batches.

[Anonymous · Accepted solution]

Try forcing BATCH to be loaded as text and not as numeric, maybe something like this :

ItemBatches_temp:

load

     ITEM,

     text(BATCH)     as     BATCH

;

SELECT

     ITEM,

     BATCH

FROM

     ITBATABLE;

[#3]

Thanks! That was the ticket!

[jagan]

Hi,

Try like this using Text()

ItemBatches_temp:

LOAD

ITEM,

Text(BATCH) AS BATCH;

SELECT

     ITEM,

     BATCH

FROM

     ITBATABLE;

Hope this helps you.

Regards,

Jagan.