Cleansing data

[kmswetha]

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]

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.

[jonathandienst]

Hi

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

Regards

Jonathan