Hi All,
I am having following data in a table.
| Dim 1 |
Dim 2 |
Dim 3 |
| 1233 |
- |
non hub |
| 21444 |
- |
non hub |
| 56574 |
- |
non hub |
| 345346 |
- |
non hub |
| 344774 |
1590 |
hub |
| 3647487 |
15998 |
hub |
| 23637476 |
2348899 |
hub |
| 353454 |
3466457 |
hub |
| 53 |
6575878 |
hub |
| 34554 |
568757 |
hub |
| 34533 |
466323 |
hub |
| 43 |
2343778 |
hub |
| 457678 |
987877 |
hub |
| 78 |
766788 |
hub |
| 7798 |
- |
non hub |
| 8765 |
- |
non hub |
| 12434 |
- |
non hub |
| - |
- |
non hub |
| - |
- |
non hub |
| - |
- |
non hub |
| - |
45347 |
non hub |
| 3435 |
575688 |
hub |
| - |
35678 |
non hub |
| - |
35656 |
non hub |
| - |
6856875 |
non hub |
| - |
35668 |
non hub |
| - |
456567 |
non hub |
| - |
7875543 |
non hub |
I want to calculate the Dim 3 as a result on a basis of following logic.
if the Dim 1 is associated with the Dim 2 then HUB and
if the Dim 1 is not associated with the Dim 2 then NON HUB
how I can achieve this scenario?
Thanks in advance!!
Regards,
Akshay Chavan
