I am trying to use the Lead Service Line Inventory Solution but am having trouble with the Data Loading Tool to upload an existing excel inventory with 1000's of points. In the Data Loading Workspace, I am able to match my source columns to my target columns, but the content of the "materials" is not being read into the target even though they are the same figuration (Non-Lead Other, Unknown - Material Unknown, etc). This is causing the "status" columns to not be calculated, leading to blank symbologies.
I have looked into the Python scripts and they are not the same lines of code that are manipulated in the "Using the Lead Service Line Inventory Solution" webinar. There is no line to calculate the "status".
How can I get the materials to be read correctly into the target?
