How to Find Matching Numbers between two Columns

[#1]

Hi,

Please assist i need to match Cell Numbers between two Columns, but the problem is

one column starts with country code 27

e.g

Column A

0738257934

the other one is

Column B

27738257934

how do i match the two in Set Analysis?

Thanks.

[morganaaron]

Would it not be easier to simply change one in the script when you're loading it, or do you not want these to be linked fields?

[#3]

Hi,

Please send me your Method that you Prefer

Regards.

[jagan]

Hi,

Try like this in script

LOAD

*,

If(ColumnA=Mid(ColumnB, 2), 1 0) AS Flag

FROM DataSource;

Now in frontend you can use like

=Sum({<Flag={1}>} MeasureName)

Hope this helps you.

Regards,

Jagan.

[prieper]

IF(LEFT(TelephoneNumber, 2) = '27', '0' & MID(TelephoneNumber, 3, LEN(TelephoneNumber) - 2, TelephoneNumber)

Peter

[morganaaron]

I'd renumber the second field. It depends on where these fields come from, but if you simply wanted to change B on load, you could write:

'0' & Mid(ColumnB, 3) as ColumnA

This would join your tables on this field however. If you don't want that to happen, you can either use Jagan's script below, or you can load as ColumnB and use an applicable statement in the frontend.

[jagan]

HI,

Try this

Hi,

Try like this in script

LOAD

*,

If(Text(ColumnA)= '0' & Mid(ColumnB, 2), 1 0) AS Flag

FROM DataSource;

Now in frontend you can use like

=Sum({<Flag={1}>} MeasureName)

Hope this helps you.

Regards,

Jagan.

[buzzy996]

use this,

=If(ColumnA='0'& right(ColumnB,9),'Matched','UnMatched')

[#9]

Hi, where will apply this to?

Expression or Load Script?

[#10]

Isn't possible to apply it on the Front End, set analysis?