Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
can anybody change the given expression and give me the same in scripting part. but want the count of matched and unmatched rows...
EXP:::
IF(IsNull(TRIM(Company_NM))
,If(UPPER(Trim([BU_SORT1]))<>UPPER(TRIM(LEFT([Common_NM],20))),'NO MATCH','MATCH')
,If(UPPER(Trim([BU_SORT1]))<>UPPER(TRIM(LEFT([Company_NM],20))),'NO MATCH','MATCH')
)
i want this to code in script but want to rename as matched and unmatched with sum
like sum(if(BU_SORT1=Common_NM),1,0) as matched
sum(if(BU_SORT1<>Common_NM),1,0) as unmatched
with the given conditions
I am trying but showing error as: multiple parameters..
Pls help
HI,
Try like this
sum(if(BU_SORT1=Common_NM,1,0)) as matched ,
sum(if(BU_SORT1<>Common_NM,1,0)) as unmatched
Regards,
Jagan.
Try like below:
Add the Flag to yuur scipt:
if( Len(Tirm(Company_NM) ,
if( upper(Trim(BU_SORT1)) = UPPER(LEFT(TRIM(Common_NM),20)) , 1 ,1 )
,0 ) AS MatchFlag
MatchFlag have 1 for match 2 for nomatch 0 for null
UI:
Counr({<MatchFlag={1}>} DISTINCTCompany_NM) --> Match Flag count
Counr({<MatchFlag={2}>} DISTINCTCompany_NM) --> NoMatch Flag count
I want them to show in the table box ,so dont want to do anything in the UI side.No falgs works out
If you need the field shows on the table box, simply convert number into text.
if( Len(Tirm(Company_NM) ,
if( upper(Trim(BU_SORT1)) = UPPER(LEFT(TRIM(Common_NM),20)) , 'Match' ,'NoMatch' )
,null() ) AS IsMatch
Dathu, I didn't get you. can you clear me.
can any body help pls