How simon29-shole/import-data-using-transform-maps works
This is an educational ServiceNow project archive, not an executable application. Its documented user-to-result workflow loads Excel data into an Import Set, applies Transform Map field mappings and coalesce logic, writes to a target table, and verifies results. The repository also preserves project materials across ideation, requirements, design, planning, development, documentation, and demonstration. No source excerpts were provided, so workflow relationships below rely on the README; the phase documents are shown as archive components, not as a runtime sequence.
Main entry points: Solution Architecture.pdf Transform Map · dataset.xlsx Excel Dataset · UAT Report.pdf Result Verification
Components 15
Import Workflow
- Excel Dataset
dataset.xlsx - Import Set
Import_Data_using_Tranform_Maps/3. Project Design Phase/Solution Architecture/Solution Architecture.pdf
Transform & Verify
- Transform Map
Import_Data_using_Tranform_Maps/3. Project Design Phase/Solution Architecture/Solution Architecture.pdf - Field Mappings
Import_Data_using_Tranform_Maps/3. Project Design Phase/Solution Architecture/Solution Architecture.pdf - Coalesce Logic
Import_Data_using_Tranform_Maps/3. Project Design Phase/Solution Architecture/Solution Architecture.pdf - Target Table
Import_Data_using_Tranform_Maps/3. Project Design Phase/Solution Architecture/Solution Architecture.pdf - Result Verification
Import_Data_using_Tranform_Maps/5. Project Development Phase/User Acceptance Testing/UAT Report.pdf
Project Materials
- Ideation
Import_Data_using_Tranform_Maps/1. Ideation Phase/Brainstorming.pdf - Requirements
Import_Data_using_Tranform_Maps/2. Requirement Analysis/Solution Requirements.pdf - Project Planning
Import_Data_using_Tranform_Maps/4. Project Planning Phase/Project Planning.pdf - Performance Testing
Import_Data_using_Tranform_Maps/5. Project Development Phase/Performance Testing/GenAI Functional & Performance Testing.pdf - Final Documentation
Import_Data_using_Tranform_Maps/6. Project Documentation/Final Report.pdf - Demonstration
Import_Data_using_Tranform_Maps/7. Project Demonstration/demo.md
Other components
- Administrator
- ServiceNow
Connections 10
- Administrator → Excel Dataset: provides
README.md - Excel Dataset → Import Set: loads into
README.md - Import Set → Transform Map: transforms through
README.md - Transform Map → Field Mappings: uses mappings
README.md - Transform Map → Coalesce Logic: uses matching
README.md - Transform Map → Target Table: writes records
README.md - Administrator → Result Verification: verifies results
README.md - Target Table → Result Verification: results checked
README.md - Import Set → ServiceNow: stages data in
README.md - Transform Map → ServiceNow: runs on
README.md