topic Re: Cleansing data in QlikView

Cleansing data

kmswetha — Thu, 16 Jun 2011 13:24:18 GMT

Hi,

I have 2 tables called DM,PM.

DM is where all my transactins get recorded and PM is just like Dimension.

For joining both the tables i have used a customer name.

Now here comes problem.CUstomer name that is DM is not straigh forword some times it is been preceeded by junk.

In Qlikview can we remove the junk and join while loading.

spividori — Thu, 16 Jun 2011 14:18:56 GMT

Hi.

You could use the sentence "exists"
Example:

DM:

load Name,

transactins;

sql select * from Table;

PM:

load Name,

field1,

field2

where exists(Name)

sql select * from Table1;

Regards.

kmswetha — Fri, 17 Jun 2011 07:50:55 GMT

jonathandienst — Fri, 17 Jun 2011 10:03:25 GMT

Please provide some examples of the junk - then I can make some suggestions.

Regards

Jonathan

kmswetha — Fri, 17 Jun 2011 10:55:43 GMT