I am facing problem designing the Solution of Below Process.
Can anyone help me in designing the Solution of This
Task1.xlsx (16.1 KB)
We have 3 Sheets: Employee, Address, Output
Copy all Content of Employee Sheet to Output Sheet
Match AddressId of “Employee” Sheet with AddressId of “Address” Sheet. If they match add the corresponding Address from “Address” Sheet to “Output” Sheet Else Write “NA” .
Print Reference in Output Sheet as Date and TimeStamp of the system at which the Address is added to the Output Sheet
The Final “Output” sheet should be similar to the “SampleOutputSheet”.