Kindly find the attached screenshot.
1. First table is the Source file.
2. Last table is Target table(Transformed table).
Now I have new requirement, if source table match with Third table then we need 2nd table as target.
3. we have 5 rows in source table which is exact match with 3rd table so we converted this into 2nd table.
Note: Only the Highlighted part needs to be converted into single row.
Kindly suggest me the logic to implement this.