Log all data in fields from all records in Table A to a single new record in Table B

But the fields in the tables are not the same. He has 7 records in Table A, with 7 fields each, and he wants to take that data and create one snapshot record in Table B with all 49 fields represented separately.

OK , now I get the ask.

"no Problem"

Set the key field of Table B to be the Date field.

Make a saved table to table copy to import Team A only into table B and map the fields into table A's set of fields.  Set the saved table to table import to merge on the date field.
Run the import manually and observe that it will create a record.  it will copy 1 record and create 1 record.


then,

Copy the saved import and change the filter to only copy Team B only but map the fields into Team B's respective fields. It will copy just 1 record, but Merge it with the existing record for that date so no new records, will be created.  

repeat for all 7 Teams.

Then just set the single Automation to run Daily, but it will have 7 steps.

Maybe set it to run every day, but filtered where some data exists to copy across, just in case they work on weekends.


 

... you will need to create a field in table called [Yesterday]
with a formula of
Today()-Days(1)

Use that field to populate the Key field of the Table B Audit logs the Automation will run each day about midnight "the next day".

Awesome, thanks for the replies! I will try your solution out Mark and let you know if I get it to working