Issue Summary: SH Group Account/Department not loading properly

The below two datafiles include a new account and department that isn’t loading properly. The records specifically, is department 000, account S60000. I’ve added that Department and Account to the Department and Account table, but it isn’t showing up. I’m guessing it has something to do with the fact that this file is not a txt file and the department column is not in txt formatting when I load it, so the system isn’t picking up the 000 or 0 Department. Can someone look at that and adjust it connector so it will capture that records? I didn’t adjust the file at all, so the way it is showing up is how it will show up going forward.

Starwood 1BB-5004 SH Group PL Actual 2022-02.xlsx
Starwood 1WH-5005 SH Group PL Actual 2022-02.xlsx

Issue Status: Issue Solved
Urgency: (2) Normal
Ticket Number: CAS-386225-Q1F3Z3
Created Date: March 23, 2022
Last Updated: March 23, 2022
Resolution Note: