Changing rows in raw data

[#1]

Hi all,

Wondering if you can help.

I have two data sources.

Data source 1                                             Data Source 2

Field called Organisation                              Field called Organisation

ABC 1                                                         P-ABC 1

ABC 2                                                         P-ABC 2

ABC 3                                                         P-ABC 3

Therefore even though the rows are the same because there is a slight spelling difference they don't join together. Is there anyway of changing data source 2 to say

ABC 1

ABC 2

ABC 3

and therefore match Data Source 1

Thanks in advance,
Rebecca

[yduval75]

Table 2

Mid(Organisation, 3)

[its_anandrjs]

Hi

Try like

Tabel1:

LOAD

Organisation as Org,

Mid(Organisation,3,Len(Organisation)) as Organisation;

LOAD

Organisation

From Source1;

Table2:

LOAD

Organisation

From Source2;

Regards

Anand

[jpapador]

Table1:

Load *

FROM Datasource1

Left Join (Table1)

Trim(PurgeChar(Organisation, 'P-')) as Organisation,

*

From datasource2;