Dot added at the time of Data Extraction from sql ... - Qlik Community

Report Inappropriate Content · ‎2017-09-20

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 · ‎2017-09-20

May be use Trim()

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Report Inappropriate Content · ‎2017-09-21

Thanks for giving time!

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

Regards,

Vishal

mostwanted123 · ‎2017-09-21

Use Num function

Num(fieldname) as fieldname

Regards,

Pratik

Report Inappropriate Content · ‎2017-09-21

Thanks!

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

Regards,

Vishal

mostwanted123 · ‎2017-09-21

Can you show an example of the data ?

marcus_sommer · ‎2017-09-21

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 · ‎2017-09-21

May be replace() will work

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

bobbydave · ‎2017-09-21

purgechar( yourTextField, '.') as newValue

Report Inappropriate Content · ‎2017-09-22

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.

Dot added at the time of Data Extraction from sql Database