I have 2 lists:
- Student (lies in student domain)
- Employees (lies in employee domain)
They both have same columns.
I would like to create a new merged list which should also include a column called 'category' which would have 2 values 'Student' and 'Employee'. I will be using PowerShell. How should I achieve this?
This would categorize the merged dataset records.
Both lists are updated daily (realtime).
Also, is there a way where I can automate this merger? (so that I do not have to manually execute the script daily)
Thanks in advance.