Hi Team, I have 2 columns Old and New which contains Text, and each substring is separated by pipe. I would like to compare the Old & New Columns and output the only substring which is unique in nature from New Column. I have created a sample data for your reference.
| Old | New | Expected Output |
| | Abc(123) | Abc(123) |
| Abc(123)|Bdc(321) | Abc(123)|Hij(432)|Bdc(321) | Hij(432 |
| Kna(987)|Hij(432)|Abc(123) | Pnr(0071)|Abc(123)|Kna(987)|Gfd(091) | Pnr(0071)|Gfd(091) |
| Hij(432)|Abc(123) | Hij(432)|Akr(779) | Akr(779) |
Kindly help me on this request, thank you for your support.
