Please help me with the expression error

[Solomoons]

Hi all,

When I wrote code in the data load editor and try to load the data the following error occurred:

And I don't know what's wrong with this sentence : if("L3"='S2'and Mid("Original MLFB",5,1)='6','S2B'&L5,L5) as S2Type

 Because there is no error notice in load editor. Could you please help me with this error? 

Any replies will be appreciated!! Thank you so much!

[agigliotti]

Hi @Solomoons ,

Maybe this:

=if(L3='S2'and Mid([Original MLFB],5,1)='6','S2B'&L5,L5) as S2Type

I hope it can helps.

Best Regards

[PrashantSangle]

your if condition looks ok. Just run your script again by commenting this if condition. If it works then try by debugging you if statement by removing one by one condition then add one by one condition.

[Solomoons]

Hi @agigliotti ,

Thank you so much for your reply. I have checked my code, there is a variable undefined in the code caused such error. And I have fixed it. Thanks again!

[Solomoons]

Hi @PrashantSangle ,

The problem has been solved, thank you so much for your help.