topic Re: Changing rows in raw data in QlikView

Changing rows in raw data

Wed, 03 Dec 2014 16:31:34 GMT

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

Re: Changing rows in raw data

yduval75 — Wed, 03 Dec 2014 16:35:43 GMT

Table 2

Mid(Organisation, 3)

Re: Changing rows in raw data

its_anandrjs — Wed, 03 Dec 2014 16:43:33 GMT

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

Re: Changing rows in raw data

jpapador — Wed, 03 Dec 2014 16:53:43 GMT

Table1:

Load *

FROM Datasource1

Left Join (Table1)

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

From datasource2;