compare the output of two expressions and get the common values

[#1]

hi,

I had a pivot table with two dimensions and two expressions.Now i need to compare the output of two expressions and get  the common values in them. can any one please help me how to do this?

LOAD (@1/86400 + 25569)  as [time stamp],

    @2 as [network id],

    @3 as msisdn

FROM



(txt, codepage is 1252, no labels, delimiter is ',', msq);

LOAD @1 as [network id],

     @2 as lat,

     @3 as long

FROM



(txt, codepage is 1252, no labels, delimiter is spaces, msq);

LOAD (@1/86400 + 25569)  as [time stamp1],

    @2 as [network id1],

    @3 as msisdn1

FROM



(txt, codepage is 1252, no labels, delimiter is ',', msq);



LoAD @1 as [network id1],

     @2 as lat,

     @3 as long

FROM



(txt, codepage is 1252, no labels, delimiter is spaces, msq);

My pivot table expressions and dimensions are something like below

lat	long	FirstSortedValue(msisdn,[time   stamp])	FirstSortedValue(msisdn1,[time   stamp1])
1.2924	103.8152	525-00-10009	525-00-10013
1.2963	103.8569	525-00-10018	525-00-10012
1.2975	103.8521	525-00-10004	525-00-10017
1.3019	103.84	525-00-10004	525-00-10002
1.307	103.8292	525-00-10020	525-00-10010
1.3098	103.8769	525-00-10001	525-00-10001
1.3122	103.7501	525-00-10016	525-00-10015
1.3129	103.9247	525-00-10011	525-00-10013
1.3218	103.904	525-00-10017	525-00-10019
1.3224	103.6572	525-00-10012	525-00-10006
1.3282	103.8862	525-00-10020	525-00-10007
1.3295	103.9668	525-00-10016	525-00-10011
1.3308	103.952	525-00-10009	525-00-10011
1.3335	103.9426	525-00-10012	525-00-10016
1.3357	103.8528	525-00-10015	525-00-10008
1.3359	103.9718	525-00-10018	525-00-10012
1.3373	103.8504	525-00-10013	525-00-10004
1.3412	103.9848	525-00-10002	525-00-10003
1.3514	103.9677	525-00-10009	525-00-10017
1.3526	103.7237	525-00-10009	525-00-10014
1.3625	103.9562	525-00-10017	525-00-10019
1.3669	103.862	525-00-10008	525-00-10012
1.3828	103.9365	525-00-10014	525-00-10016
1.4217	103.8375	525-00-10004	525-00-10008
1.4265	103.8343	525-00-10019	525-00-10001
1.4275	103.837	525-00-10012	525-00-10016
1.431	103.8376	525-00-10007	525-00-10019
1.443	103.7879	525-00-10005	525-00-10010
1.4484	103.8	525-00-10012	525-00-10003
1.4485	103.806	525-00-10006	525-00-10009

        Now i want to get the get the common values in both the expressions. please help me how to do this

http://192.168.127.79/PEARL.pac

[tresesco]

Do you want a third expression which tells if the first and second expressions match? If so, try third expression like:

If( FirstExpressionLabel=SecondExpressionLabel, FirstExpressionLabel)

// change the label accordingly.

[#3]

Hi,

You can use the * .It means intersection which take the common values between two expressions

Expression3=Expression1*Expression2

Hope it helps you

[#4]

hi,

i need to get the common values only. something as below. no need of getting the firstsorted value

lat     long     msisdn     msidn1     commonvalues(msisdn ).

I need to display this in a pivot table.