How to find Field values are Exists or not between the two Fields of same Table

[akshay_chavan]

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

[anat]

if(len(Dim1)>0 and len(Dim2)>0,'hub','Nonhub')