Moving data from one excel file to another with different columns


I have a problem that I cannot seem to find an answer to on the forum after attempting all day.

I am using document understanding to extract data from PDF files which generates an excel file.

I need to somehow move that data into a new excel template to upload elsewhere.

I cannot modify the column names in either file
The column names do not all match
If the column names match they are in a different index order

I think this can be achieved with manipulating the data extraction data table but I can’t seem to figure it out.

Could someone help me solve this problem?

Thank you,

I have spent the past 3 hours working on using invoke method which also does not seem to work.

I set an ordinal value for each of the columns and they still write in the same incorrect order…

use build datatable activity to build a new datatable according to your template and loop through each row in the old datatable to assign it to new one

1 Like