Using Multiple Transform maps for data received from 3rd Part

[EricG]

Hello Guru's:

Looking for the best method to transform data from a 3rd party for Computer information being sent to us.

Case:

When our inventory department orders a batch of computers from Dell. (maybe 10 to 48 at a time), I get two files from them when the computers are built (excel and csv).  The information contained with in has information such as:
Operating system

Memory

Model

PO Number

Serial Number

Etc.

I have 2 transform maps created that migrates the information to the cmdb_ci_computer  and alm_asset tables.

All information is being process accurately and no duplicates are create!  YIPPIE.   I'm having difficulty getting the email processed and running the two transform maps.  I may have set this up incorrectly.

What I've Done.

When the email comes in, I add the Excel file to a import staging table called dell_report_import.  From there my two transform maps add data to the CI table and then the Asset table.  Manually, it works create.  But the inbound action i have for this will only run the First transform map, which adds the information to computer table.

Since the files i get vary in file name (typically include date of report at the end), Im not sure the suggestions on setting update Run Batch on data source apply.

I originally followed the suggestions found in this post
https://www.servicenow.com/community/developer-blog/loading-data-from-an-email-attachment/ba-p/22797...

But only 1 transform map runs.

Any suggestions?  I'm more than happy to post/add any further details as needed.