Data Cleansing

Hi,

I have a formula in place where [Program] NOT IN ('01','04','05') then 'program error', the excel report does have the leading zeros 01, 05, 04 and it is a V string. When I run the workflow it states program error? I do have data cleansing to remove leading and trailing white space. is that what is causing it? Any ideas?

thanks!

Datasets

Accepted answers

binu_acs

@VeronicaElse I am getting the result properly. Can you compare with your workflow ?

programerror.yxmd

All comments

Luke_C

Can you share a screenshot

binu_acs

@VeronicaElse I am getting the result properly. Can you compare with your workflow ?

programerror.yxmd

VeronicaElse

Thanks for replying-I have a huge formula so it keeps going in this pattern -elseif [Plan Co] not in ('16','15','K3','K2') then 'plan code error' elseif -------- etc etc and I end it with --else Null() endif

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703