Is it possible to join and update these files

Question
1

Hi, I need to update the dates on sheet 1 to the dates on sheet 2. I need to do it by using the matching number to know what date to update. I have no idea how this.

sheet1.csv (63 Bytes)

sheet2.csv (95 Bytes)

Any thoughts?
Thank you
Kim

2

You can do this with a simple Join. Then Remove Cols to get rid of the original dates.

join
join2125×1124 189 KB

See also:
https://www.easydatatransform.com/join_csv_files.html

3

Thanks, I was over thinking it.