CREATE A fields that holds some expected values from 2 fields

Raya — Fri, 15 Nov 2024 13:02:21 GMT

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

Re: CREATE A fields that holds some expected values from 2 fields

brunobertels — Fri, 15 Nov 2024 16:03:48 GMT

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

topic Re: CREATE A fields that holds some expected values from 2 fields in App Development

CREATE A fields that holds some expected values from 2 fields

Re: CREATE A fields that holds some expected values from 2 fields