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

akshay_chavan — Mon, 04 Apr 2022 11:15:14 GMT

Hi All,

I am having following data in a table.

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

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

anat — Mon, 04 Apr 2022 11:19:02 GMT

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