Leading spaces and zeros

[kulasekhar]

Hi guys.

I need help on an issue. I have a view in sql server that brings two records 539681 17 and 0053968117.

These are two different items.When i  make a select from that view on a qvw the result is that it brings only one of the records.

I have tried Text(ITEM_NUMBER) but it didnt work. Can anyone help?

See below Database Tale:

ITEM_NUMBER,  BASELINECUT

0056729003,         TERMINATED

56729003SUB1,    IN_PRODUCTION

539681 17,           IN_PRODUCTION

0053968117,         TERMINATED

063230100511,      TERMINATED

63230100511,         IN_PRODUCTION

I want show  data same as database with leading zeros, spaces and any caraters(56729003SUB1).

Mine showing wrong ITEM_NUMBER, are 539681 13,539681 17,539681 19,56729003,56729004,63230100511.

Please find the QVW and QVD.

Thanks

Sekhar

[quwok]

This is Qlik's automated data cleansing in action, you'll need to force the value into text using the text() function in your load script.

[sunny_talwar]

I don't see 0053968117 in your attached qvd... are you sure this row is in your qvd?

[kulasekhar]

Hi Sunny,

Can you search in ITENUM list box 539681 17. we can same ITENUM(539681 17) two BASELINECUT.

but Data base showing like this 1)539681 17, 2)0053968117

Thanks

Sekhar

[sunny_talwar · Accepted solution]

So you need to fix this before you create the qvd... can you share the script you used to create the qvd? because one the qvd is created, there is no way to know which row belongs to which ITEMNUM.