topic Data Cleaning Fuctions in QlikView

Data Cleaning Fuctions

Mon, 13 Jul 2009 17:22:59 GMT

Hi all

are there any Data Cleaning Fuctions in QlikvIEW?IF there are ,please let me know?

Thank you

Regards

Sikandar

Data Cleaning Fuctions

stephencredmond — Mon, 13 Jul 2009 17:52:09 GMT

Hi Sikandar,

That is a very broad question and I can simply answer, "yes".

That might not be useful for you.

What type of data are you trying to clean? What type of cleaning are you looking for?

Regards,

Stephen

Data Cleaning Fuctions

Mon, 13 Jul 2009 18:59:26 GMT

Hi Sikandar,

Can you explaing with an example what exactly you are looking out for?

Regards,

Amit

Data Cleaning Fuctions

Tue, 14 Jul 2009 12:22:11 GMT

Hi Stephen and Amit

I was just asking as it now i donot have to use them in any application .As i read some where that there are data cleaning functions in qlikview so

i thought i should ask.....Can you people give me some details about data cleaning functions.Why these fuctions are use?Where they are located in QlikView?

Any example will be helpful..

Regards

Sikandar

Data Cleaning Fuctions

stephencredmond — Tue, 14 Jul 2009 15:33:03 GMT

Hi Sikandar,

Your query is too broad. You need to tell us what you want to do.

Trim() is a "data cleaning" function.

Regards,

Stephen

Data Cleaning Fuctions

Tue, 14 Jul 2009 15:46:30 GMT

What kind of data cleansing function are you looking for....?

Of course there are some functions

1. trim(), rtrim(), ltrim() - to remove spaces in ur fields..

2. capitalize(), lower(), upper() - to convert all characters respectively.

3. mid(), subfield().... for respective operations..........

to name a few...

u can get a complete list of all functions in the qlikview help....

Kindly note that these functions can be used within qlikview. as must be aware qlikview can only read data from the database and not modify/alter anything.

Data has to be loaded in qlikview first, and then appropriate functions can be used within qlikview anc saved in a qvd format.....

this qvd in turn can be used within qlikview ONLY........