topic Data Format in QlikView

Data Format

marcorizzo — Fri, 19 Jun 2015 07:30:21 GMT

I'm loading data from a mysql database.

There a couple a fields that are not formatted in the right way (in qvw file you can see the field oggettoWEB).

How can i solve ?

Thanks

Re: Data Format

fvelascog72 — Fri, 19 Jun 2015 07:35:53 GMT

Hi,

Which is the format what are you looking for?

I think you could convert all with UPPER or with LOWER or maybe with CAPITALIZE.

From help:

UPPER:

upper( 'abcD' ) returns 'ABCD'.

LOWER:

lower( 'abcD' ) returns 'abcd'.

CAPITALIZE:

capitalize ('my little pony') returns 'My Little Pony'

capitalize ( 'AA bb cC Dd') returns 'Aa Bb Cc Dd'

Re: Data Format

jagan — Fri, 19 Jun 2015 07:49:01 GMT

Hi,

You can use various string functions like

Upper()

Lower()

Capitalize()

based on your requirement.

Regards,

Jagan.

Re: Data Format

marcorizzo — Fri, 19 Jun 2015 09:20:15 GMT

Hi. The problem is that when i take data from the mysql db, i've got this strange situation :

1. AS IT COULD BE : è andato via

2. THIS IS WHAT I'VE GOT : &egrave andato via

😞

Re: Data Format

jonathandienst — Fri, 19 Jun 2015 09:26:13 GMT

That is an encoding problem - the data has been encoded in the database and you will need to decode the unicode entity codes.

You can do this with MapSubstring like this:

//place this before loading from MySQL

MapDecode:

Mapping LOAD * Inline

[

Code, Char

&egrave, è

...

];

//Your MySQL load

LOAD *,

MapSubstring('MapDecode', myField) As Decoded

;

SQL SELECT ....

;

Add more entity decodings to the inline load according to your needs. And change the field name 'myField' to the correct name of the field you want to decode.

Re: Data Format

marcorizzo — Fri, 19 Jun 2015 09:35:16 GMT

Thanks a lot !!!

It works...