Code Mismatch should be displayed as Undefined

[#1]

HI All,

I have a scenario where my data is something like below.

Code      Element

43-AB     43-AB-ASD

54-AB     54-AB-CDF

And another table where data is like below

Element

Loan Details

Payment Details

I need to categorize the above values as Undefined in Code.

If i select Undefined in code then it should display element as

Loan Details

Payment Details

Please help me with this.

Regards,

Keerthi KS

[vikasmahajan]

In load statement you can add following script

if( code = 0,1,if(ISNULL(code) OR LEN( code)=0,1,0)) AS Undefined,

and filter the same

HTH

Vikas

[#3]

Hi,

Try like below,

Load

if(wildmatch(Element,'Loan Details','Payment Details'),'Undefined',Code) as Code,