Copy from one excel datatable format to another datatable formart

[CHAN_Hiu_Fung_Victor_Stud (CHAN, Hiu Fung Victor [Student])]

Hi guys,

I would like to ask how can I copy the date from the source file into the destination file, as their table format is different.

As you can see, the date from “source” is displayed based on the ID, so if I extract it it will display 4 rows of the date based on ID. However, the destination file needs to display the date for more rows. How can I cope with the date with the different format, assuming the ID will keep increasing from time to time?
Thanks!!!

Source.xlsx (9.1 KB)

Desntination.xlsx (9.3 KB)

[rlgandu (Rajyalakshmi Gandu)]

@CHAN_Hiu_Fung_Victor_Stud

If you want to read the excel data to a datatable and write it in destination file.Then simply Use Read Range and write Range activity.But as we see in your destination file you have No,Date,ID columns If your Destination file have data but dates are not present then you have to take the condition that your “ID” columns in two datatables Match then it has to write the Date of 1st datatable to Destination File.

[Parvathy (PS Parvathy)]

Hi @CHAN_Hiu_Fung_Victor_Stud

Can you share what the expected output looks like. I can help you with workflow.

Regards

[FerdinanAlberto]

You wnat Output Like This?

If Yes here the xaml you can use,
but first just let the Destination sheet Empty.
CopyExcel.xaml (12.8 KB)

[CHAN_Hiu_Fung_Victor_Stud (CHAN, Hiu Fung Victor [Student])]

Thanks for your help! It works!