Group by on a column and select records containing particular string

[keeprollin]

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

[binu_acs]

@keeprollin This can be done with the help of the filter tool

[MilindG]

You can just use the filter tool which contain ('XYZ') please see the attachment

[Biswarun]

How does your output contain 5867 - G002DF?

Otherwise, please consult the attached workflow.