Hello,
is there any way to map a column based on 2nd character from other column
Input file 1
Product |
0AY |
0BJ |
0GW |
0DL |
Input file 2
2nd Character |
A |
B |
C |
D |
Output file
Product | 2nd Character | YES/NO |
0AY | A | YES |
0BJ | B | YES |
0GW | C | NO |
0DL | D | YES |
Third row is "NO" because 2nd character doesn't match between 1st and 2nd character.
Solved! Go to Solution.
Third row is "NO" because 2nd character doesn't match between 1st and 2nd input files
@kauser one way