Hello,
I have multiple csv files. These files need to be updated based on data contained in another csv file which is used
as a reference.
All records containing a key in the csv files that is not in the reference file should be removed. All records containing a key that is in the reference file, the key has to be updated and replaced by its mapping key which is in the reference file.
Here is an example:
I have a directory which has multiple csv files.
The format is as such
tagname date (csv1.csv)
1234A 1998/02/04
1235B 1998/02/04
1235B 1998/02/03
The reference file contains (ref.csv)
oldtag new tag
1235B X1235B
In this case csv1.csv should drop 1234A since
it is no longer in ref.csv and should replace
all occurences of 1235B by X1235B.
Thanks
I have multiple csv files. These files need to be updated based on data contained in another csv file which is used
as a reference.
All records containing a key in the csv files that is not in the reference file should be removed. All records containing a key that is in the reference file, the key has to be updated and replaced by its mapping key which is in the reference file.
Here is an example:
I have a directory which has multiple csv files.
The format is as such
tagname date (csv1.csv)
1234A 1998/02/04
1235B 1998/02/04
1235B 1998/02/03
The reference file contains (ref.csv)
oldtag new tag
1235B X1235B
In this case csv1.csv should drop 1234A since
it is no longer in ref.csv and should replace
all occurences of 1235B by X1235B.
Thanks