Hello Team,
How can we perform Following activities
1.For Each PId in TheSourceFile.xlsx
Search that PID in Material_Data2024
If Found Get the Column Name (Type Data) and Paste in TheSourceFile.xlsx
Skt Column Field
Else
If Not Found then add -1 in Skt
Example 88989 contains Type as 90
So Skt will be 90
Original File Format
|PID |Skt|
|999993| |
|99086 | |
|88989 | |
**Reference Material File **
|UPAC|Type|Name|
|—|—|—|
|999993|610|CGM|
|99086||NXX|
|88989|90|YNN|
Final Output File Format
|PID|Skt|
|—|—|
|999993|610|
|99086|-1|
|88989|90|
Attached Reference File
Material_Data2024.xlsx (4.9 KB)
TheSourceFile.xlsx (4.7 KB)
