Goal : Distribute the data as below condition -
Given : FileA and FileB contains some data in single column.
Target : File_A : Which contains the data which is available in A but not in B
Target : File_B : Which contains the data which is available in B but not in A
Target : File_AB : Which contains the data which is available in A and B Both
| FileA | FileB | ||
| 1 | 9 | ||
| 2 | 10 | ||
| 3 | 11 | ||
| 4 | 12 | ||
| 5 | 13 | ||
| 6 | 14 | ||
| 7 | 15 | ||
| 8 | 16 | ||
| 9 | 17 | ||
| 10 | 18 | ||
| 11 | 19 | ||
| 12 | 20 | ||
| 13 | 21 | ||
| 14 | 22 | ||
| 16 | 23 | ||
| OutPut | |||
| File_A | File_B | File_AB | |
| 1 | 17 | 9 | |
| 2 | 18 | 10 | |
| 3 | 19 | 11 | |
| 4 | 20 | 12 | |
| 5 | 21 | 13 | |
| 5 | 22 | 14 | |
| 6 | 23 | 15 | |
| 7 | 16 | ||
| 8 |
No comments :
Post a Comment