Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
kulasekhar
Creator
Creator

Leading spaces and zeros

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_NUMBERBASELINECUT

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

1 Solution

Accepted Solutions
sunny_talwar

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.

View solution in original post

4 Replies
quwok
Creator III
Creator III

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
Creator
Creator
Author

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

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.