Hello community,
In the given sample file, the column Master ID may have one or more IDs. I need to group by on each Master ID and select only the IDs which start with XYZ. Could someone please let me know a solution to it? I thought of creating a record ID column and performing a count on it to filter records >1, but it should not be the correct solution.
Account | ID | Master ID |
4658 | G002AB | G002AB |
4735 | XYZ00005645 | G002AB |
5867 | G002DF | G002DF |
2735 | XYZ00005364 | G007DF |
6970 | G007DF | G007DF |
5854 | G00GBD | G00GBD |
4678 | G00YR5 | G00GBD |
9783 | G01GY6 | G00GBD |
5760 | G02IPY | G00GBD |
2354 | G03U75 | G00GBD |
5375 | XYZ00001202 | G00GBD |
1243 | XYZ00001459 | G00GBD |
3749 | XYZ00005382 | G00GBD |
9880 | XYZ00004857 | G00GBD |
I'm expecting my final output to look something like below:
Account | ID | Master ID |
4735 | XYZ00005645 | G002AB |
5867 | G002DF | G002DF |
2735 | XYZ00005364 | G007DF |
5375 | XYZ00001202 | G00GBD |
1243 | XYZ00001459 | G00GBD |
3749 | XYZ00005382 | G00GBD |
9880 | XYZ00004857 | G00GBD |