Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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.
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!
Hi @PrashantSangle ,
The problem has been solved, thank you so much for your help.