Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have this if condition, but it's not working for some reason. Can anyone tell me what am I missing here?
Load if((Country = 'United States of America' or Country ='China' or Country ='Taiwan' or Country ='Germany (Federal Republic of)' or Country ='Netherlands') and ( "Status"= 'Allowed' or "Status"='Granted')
and( Company = 'ABC')
and (DFAnalysis = 'Low')
AND (IFSCORE >= 3), 'LOW', 'NA') as Stage, ID
Resident Temp;
Thank you.
Hi,
Please try wildmatch in place of "(Country = 'United States of America' or Country ='China' or Country ='Taiwan' or Country ='Germany (Federal Republic of)' or Country ='Netherlands')
"
like
if(wildmatch( Country, 'United States of America' ,'China' ,'Taiwan' ,'Germany (Federal Republic of)','Netherlands') >0
and wildmatch(Status,'Allowed','Granted')>0 .........
Hi,
Try this
Load IF( Match(Country, 'United States of America', 'China', 'Taiwan', 'Germany (Federal Republic of)', 'Netherlands')
AND Match(Status, 'Allowed' , 'Granted')
AND Company = 'ABC'
AND (DFAnalysis = 'Low'),
IF(SCORE >= 3, 'LOW', 'NA')) as Stage,
ID
'
'
'
Hope this helps you.
Regards,
Jagan.
Hi,
Load if(wildmatch(Country,'United States of America','China','Taiwan','Germany (Federal Republic of)', Country ='Netherlands') >0
and wildmatch(Status= 'Allowed','Granted')> 0
and wildmatch(Company,'ABC') >0 and
wildmatch(DFAnalysis,'Low') >0
AND IFSCORE >= 3, 'LOW', 'NA') as VettingStage,
ID
Resident Temp;
I am getting only one value for VettingStage field which is NA, and this means something is worng in this condition. Can you please check?
Thanks a lot for your reply.
Hi,
Try this.its working fine.
test:
Load * Inline
[ Country,Status,Company,DFAnalysis,IFSCORE
United States of America,Allowed,ABC,Low,5
China,Granted,ABC,Low,8
];
load
if(
(wildmatch(Country,'United States of America','China','Taiwan','Germany (Federal Republic of)', 'Netherlands') >0 )
and wildmatch(Status, 'Allowed','Granted')> 0
and (Company='ABC')
and (DFAnalysis='Low')
and IFSCORE >= 3,
'LOW', 'NA') as test1
resident test;
hi,
Ur condition was failing in line
1) "if(wildmatch(Country,'United States of America','China','Taiwan','Germany (Federal Republic of)', Country ='Netherlands') >0"
observe in this line u have used " Country ='Netherlands' " ,this is wrong syntax, as u have alredy mentioned Country field as first parameter in wildmatch function
2) " wildmatch(Status= 'Allowed','Granted')> 0
and wildmatch(Company,'ABC') >0
"
beacuse you putted "=" sign after status inplace of "," .
Also we dont need to put wildmatch or match when we have only one value to cample in field, so no need of using wildmatch for "Company" "FAnalysis".
LOAD
if(
(
Country = 'United States of America' or
Country ='China' or
Country ='Taiwan' or
Country ='Germany (Federal Republic of)' or
Country ='Netherlands'
)
AND
(
"Status"= 'Allowed' or "Status"='Granted'
)
AND
(
Company = 'ABC'
)
AND
(
DFAnalysis = 'Low'
)
AND
(
IFSCORE >= 3
)
,'LOW','NA')
MAY be it's run
Hi,
Load if(wildmatch(Country,'United States of America','China','Taiwan','Germany (Federal Republic of)', 'Netherlands') >0 and wildmatch(Status= 'Allowed','Granted')> 0
and( Company = 'Apple')
and (DFAnalysis = 'Low')
AND (IFSCORE >= 3), 'LOW', 'NA') as VettingStage,
ID
Resident Temp;
I am using this, but its still not working. also, I tried breaking this if statement but, only the country condition in the above is working and no other condition seems to be working fine. I am not sure about the reason, can you please tell me what could be the reasons?
Thanks a lot.
hi,
their is error in ur secound line "wildmatch(Status= 'Allowed','Granted')> 0" that you have written ,
dont write "=" sign after Status it should be "wildmatch(Status, 'Allowed','Granted')> 0".
I mentioned it above also.
Please correct this line.
Hi, I corrected this error, but by mistake I posted it here. Sorry about that. All my conditions worked except these :
Company = 'Apple' and IFSCORE>=3 and NOT Tag LIKE '*Rejected*'
So, when I run my script with the following code it runs fine:
Load if(wildmatch(Country,'United States of America','China','Taiwan','Germany (Federal Republic of)', 'Netherlands') >0 and wildmatch(Status, 'Allowed','Granted')>0
and (DFAnalysis = 'Low')
, 'LOW', 'NA') as VettingStage,
ID
Resident Temp;
But, when I am adding the above 3 conditons , I only get output as NA for the Vetting stage field.
I am using the following expression.
Load if(wildmatch(Country,'United States of America','China','Taiwan','Germany (Federal Republic of)', 'Netherlands') >0 and wildmatch(Status, 'Allowed','Granted')>0
and Company = 'Apple' and IFSCORE>=3 and NOT Tag LIKE '*Rejected*'
and (DFAnalysis = 'Low')
, 'LOW', 'NA') as VettingStage,
ID
Resident Temp;
Tag is a field name in my data model. I tried running my script, but any of these above conditions are not working, even though I have records that satisfy these conditons.
Thank you. I would really appreciate your response.