Adding the current date to the file

Question

Hello,
I have a file which has duplicates. My task is to remove the duplicates and overwrite the file. I would also like to save the original file with the duplicates (historical data), adding today's date to each. So in a workflow I would have to do 2 things:
- before I delete the duplicates save the file in another location by adding today's date to the file title;
- remove the duplicates from the original file and overwrite it.

So far I have been doing this manually. Is there any way to automate this. Thank you in advance.

Numbers.xlsx

binu_acs · Answer

@Luk88kk updated the workflow with some documentation for better understanding

file1.yxmd

atcodedog05 · Answer

Hi @Luk88kk

You need to add the full path here in the formula too.

Hope this helps : )

Luk88kk · Answer

Hi @atcodedog05

Thank you for the hint.

But please tell me what about the earlier output "test_original" (3)?

I noticed that if we use "./" - the file will automatically be saved where the workflow is saved. However, I would like the file to be saved in a separate folder.