I'm fairly new to Synctool. I am attempting to compare a field in one record to a field in another record and when they match, pull a third field from one of the records. Sample data:
Record 1: Field_A Field_B Field_C
Record 2: Field_X Field_A
When Field_A matches, pull Field_C and output to new file: FIeld_X Field_A Field_C
Your assistance is appreciated.