Changing names from free text fields

[rcorcoran]

Hi

I have data in from a free text column.  I want to be able to change the variants of the names that the owners have typed in so that they show as one with the data against the one name

for example there is hele and helen in for the owner helen with orders against each so in a table i want the results to show the total orders for helen which will include any she put up as hele

if anyone could help it would be great.

Thanks

[rajat2392]

count({<owner='hele*'>}orders)

try this..but what it does is after hele, whatever comes, it will count in it....

else if you know the possible names of a single owner, then while loading load it as a single name, or hard code it in expressions for all possible names. 

[CELAMBARASAN]

If you know the possibilities then got with Mapping table and apply map

OwnerMapping:

Mapping LOAD * Inline [

Name, OriginalName

hele, helen];

Load *, Applymap(Owner, 'OwnerMapping', Owner) AS OwnerMapText

From source;

By doing this, 'hele' will be changed to 'helen'.

[ThornOfCrowns]

Are you sure you don't need a wildcard (*) in there?

i.e.

<Owner={"Hele*"}>

A problem occurs if you have distinct owners called Helen or if you have an owner called Helena

[rustyfishbones]

Hi Rhona,

The best way to manage this would be by using a Mapping Table

like what celambarasan has suggested

Regards

Alan

[rajat2392]

please read the second line also...