I have two csvs that I am using to get the difference in status
my first csv is something like
past.csv
STIG, VKEY, Status
Windows 7, V-12345, Closed
Windows 7, V-12345, Closed
Unix, V-6789, Open
my second csv is something like
current.csv
STIG, VKEY, Status
Windows 7, V-12345, Open
Windows 7, V-12345, Closed
Unix, V-6789, Closed
I am trying to create a code that reads both and output in a separate csv the lines that show a change from open to close and close to open.
So my new csv will be
STIG, VKEY, Status
Windows 7, V-12345, Open
Unix, V-6789, Closed
This is my code where I got stuck
It is currently displaying all the lines like:
STIG , Vkey , Status
Windows 7, V-12345, {@{Status=Closed…
Windows 7, V-12345, {@{Status=Closed…
Unix, V-6789, {@{Status=Open…