Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

SAP Connector problem automatiquely delete 0

Hello,

I have a problem on a request that I make directly into an Oracle database (I use the SAP connector).

I have  one field Material and I have two different Materials is called :

07355606 and 7355606 I do not understand why QlikView removes the 0 automatiquely me before the 7 I find myself with two 7355606 Material.

Someone an idea?

Thank you.

Labels (1)
1 Solution

Accepted Solutions
Not applicable
Author

This is expected as QlikView decide to interpret this as a number, just use the text() Function so all entries are stored as String

View solution in original post

1 Reply
Not applicable
Author

This is expected as QlikView decide to interpret this as a number, just use the text() Function so all entries are stored as String