Hi @ARUP DEBBURMAN ,
Sorry for the delayed response and thanks much for sharing additional information.
You can use below expression in your derived column expression builder:
case (
(isNull(GUPPLIERCODE) || (upper(GUPPLIERCODE) == 'NULL') || GUPPLIERCODE == '0') , '',
and(not(isNull(GUPPLIERCODE) || (upper(GUPPLIERCODE) == 'NULL')), like(GUPPLIERCODE, '%_%')) , split(GUPPLIERCODE, '_')[1] ,
GUPPLIERCODE
)
Please see below test results (You can further modify this expression based on your case statements )
Hope this helps. Do let us know if you have further query.
----------
Please don’t forget to Accept Answer
and Up-Vote
wherever the information provided helps you, this can be beneficial to other community members.