DATA Quality

[#1]

Hi Everyody ,

I have a little  problem , i want to contrôle the quality of my Data , for example

2 rows :

GASQUET laurent

gasquet LAURENT

For me is the same rows but QLIK VIEW Loaded me GASQUET laurent and gasquet LAURENT

So someone have idea to get some controle of my data

Thank You

[ThornOfCrowns]

Answered in your other thread:

http://community.qlik.com/thread/106964

[#3]

Use Capitalize function while loading data.

[mahesh_agrawal]

Hi,

If you need ur output as Gasquet Laurent', then use Capitalize().

If u want it as 'GASQUET LAURENT', then upper(Capitalise(Name)).

[Sokkorn]

Hi,

We can use Lower(), Upper() and Capitalize() to do this job.

Example:

Lower( 'abcD' ) -> returns abcd

Upper( 'abcD' ) -> returns ABCD

Capitalize( 'AA bb cC Dd') -> returns Aa Bb Cc Dd

Regards,

Sokkorn

[ashwanin]

Hi you can do this by using function Capitalize.

It will make your data proper and help in improving the quality. You just need to put below in your script.

Capitalize(your_field_name) as your_field_name

[#7]

Check the attached QV.