Hello to the community,
I want to multiply fields from different source documents based on the field names being identicle, i.e. see attached:
So multiply 'person 1' hourly rate by 'person 1' number of hours worked, to create a new field 'Employee Cost' for person 1, person 2, etc. per month.
This is just a simple example representing what I am trying to do, there are 100s of fields in my data . What is important is that the multiplication only takes place if the names are identical.
Join doesn't work because it renames the field names which are not unique - anyone have a possible solution?
