topic Re: Dot added at the time of Data Extraction from sql Database in QlikView

Dot added at the time of Data Extraction from sql Database

Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

When I am fetching the data from sql database, Unnecessary dot(.) has been added in data after store the qvd.

For example if in database '46' value is there some field but when I am fetching it is '46.' in qlikview.

here in DB field length is 2 but in qvd its length of 3.

Can Anybody has any Suggestions in this regards, then please help.

Regards,

Vishal Modi

Anil_Babu_Samineni — Thu, 21 Sep 2017 01:08:10 GMT

May be use Trim()

Thu, 21 Sep 2017 05:05:44 GMT

Thanks for giving time!

I already used Trim(), But its not work.

Regards,

Vishal

mostwanted123 — Thu, 21 Sep 2017 05:26:30 GMT

Use Num function

Num(fieldname) as fieldname

Regards,

Pratik

Thu, 21 Sep 2017 06:03:11 GMT

Thanks!

Cant use num function, because this is a text field in database.

Regards,

Vishal

mostwanted123 — Thu, 21 Sep 2017 13:08:08 GMT

Can you show an example of the data ?

marcus_sommer — Thu, 21 Sep 2017 13:14:26 GMT

I would try to load this field with: text(Field) within a Preceding Load. If this don't work I would look for a different database-driver.

- Marcus

ramasaisaksoft — Thu, 21 Sep 2017 13:44:12 GMT

May be replace() will work

REPLACE(TextString,'.','') AS TextString

bobbydave — Thu, 21 Sep 2017 14:40:47 GMT

purgechar( yourTextField, '.') as newValue

Fri, 22 Sep 2017 05:45:35 GMT

For example if in database '46' value is there some field but when I am fetching it is '46.' in qlikview.

here in DB field length is 2 but in qvd its length of 3.