I have a datatable as shown below in the screenshot:
First, it should position the new column “Department” in between “Name” and “Working Hours” (i.e.,at index 2).
As you can see, I have highlighted the “ID” column, and depending on the IDs, we have to populate the newly added “Department” column conditionally:
1,4 - IT(Yellow)
2 - Accounts(Green)
3 - Finance(Blue)
Given below is what the results should look like:
Help would be most appreciated, thanks in advance!