Appending CSV file with new row and column?????
I am trying to append the CSV file with data from other csv file but not able to get the output.
I have 2 csv file and want 2nd csv file result to append to 1st csv file and add column from 2nd csv file.
1st CSV file:
| ComputerName | User | Port |
|---|---|---|
| Server1 | abc | 132 |
| Server1 | xyz | 321 |
2nd CSV:
| ComputerName | Connection |
|---|---|
| Server2 | connection issue |
Expected output:
| ComputerName | User | Port | Connection |
|---|---|---|---|
| Server1 | abc | 132 | |
| Server1 | xyz | 321 | |
| Server2 | connection issue |
I have multiple thinks but not able to add the column.
Can we add this and how this can be achieve?
Thanks!
Posted Sep 17, 2021, 5:52 AM UTC
21