ADI Comparison Dashboard
Process Excel Files - Match Rows
Ready
Select File to Process
Quick Actions
BIS Banned List
Downloads from Trade.gov and re-indexes into Azure AI Search.
Instructions
How to use:
- Select an Excel file from the list
- Click "Process File - Find Matches"
- System processes ALL rows with data
- Removes duplicate rows
- Creates/Updates worksheet: "Match_Sheet"
- Copies only specific columns (see below)
- Color codes rows:
- Green = Match (Primary == Secondary)
- Yellow = No Match (Primary != Secondary)
- Overwrites the original file
Duplicate Detection:
Rows are considered duplicates if ALL 14 column values are identical (case-insensitive). Only the first occurrence is kept.
Columns Included:
Primary Distributor:
- Name
- Address
- City
- Country Code
- State
- Postal Code
- Name
- EC Address 1
- EC City
- EC Country
- EC State
- EC Postal Code
Example:
Row 5:
Primary_Disti_Name: ABC Corp
Secondary_Disti_Name: ABC Corp
Match! Added to Match_Sheet
Result:
The original file is updated with a new "Match_Sheet" worksheet added.
If Match_Sheet already exists, it will be replaced with fresh data.