How to write condition by using mutiple columns to create one column in script
I need help to create new column by using mutiple column conditions. Actually i have few columns like ID,
Comments, Withdrawn Description, Status and Withdrawn Reason. By using these columns i need to create new Column as Categroy. In Category columns we need to define three values i.e. Code, Lack, Reason.
I am giving conditions to create a New column Category by using below points.
1)Categorize as Code, if “Withdrawn” is not in the Comments and/or Withdrawn Description.
2)Categorize as Lack, if Null and/or N/A are in the Comments and Withdrawn Description
3) Categorize as Reason, if keyword match in the comments and/or withdrawn description does not align with Withdrawn reason
a) ID was submitted
“ID submitted in error”, ”Mistake”, ”Working Fine” or “Invalid”