Hi Experts,
in my scenario there is a value that is comming from source need to be substring depending on some condition eg: Electrical:Cable as per the req we need only Cable this could be achived by using the substring function but if there is a null value comming from the source then it should write a null at the target
but when we are using substring function to get the value eg Cable it works fine but when there is a null value it throws a error on substring function
can anyone provide the inputs as the req is critical
Thanks
Sampath