CREATE A fields that holds some expected values from 2 fields

[Raya]

Hi experts,

would you please help me here..!!

I wanted to get the create a field that get the data having in 2 fields. i tries using if and wildmatch but unable to progress.

if(wilmatch(QN, *NL_AMS_NSO*, *ALU_CFN*) or wilmatch(QN1, *NL_AMS_NSO*, *ALU_CFN*)) AS QF.HERE QN AND QN1 are 2 fields present in same table what every the values that match in wild match from 2 fields will be present in QF field

Thanks in advance

[brunobertels]

Hello 

you miss the input result in your is statement 

If( X = TRUE , 1 , 0 ) 

So it could be 

if(wilmatch(QN, '*NL_AMS_NSO*', '*ALU_CFN*') or wilmatch(QN1, '*NL_AMS_NSO*', '*ALU_CFN*')

, QN &' / '& QN1 , null()

) AS QF