Add new column acces and if department having marketing or anything replace as per given output

Hi @Ravi_Shirsath,
from my understand you have data table and you want to add another column to it with above data if so find below steps to achive that.
1- After extract employ data table you need to add new column use (Add Data Column) Activity - check below link for that

2- Create For Loop for the extracted data table (Employee Table) and inside the for loop add data row.

Please check and update us if you still has issue :slight_smile: