Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
(
LOAD @1 as [network id],
@2 as lat,
@3 as long
FROM
(
LOAD (@1/86400 + 25569) as [time stamp1],
@2 as [network id1],
@3 as msisdn1
FROM
(
LoAD @1 as [network id1],
@2 as lat,
@3 as long
FROM
(
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
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.
Hi,
You can use the * .It means intersection which take the common values between two expressions
Expression3=Expression1*Expression2
Hope it helps you
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.