Exclude Data from Input File based on Business rules

[kal-tech]

Hi All:

Could you please help how to get the output file from the input file as stated below.

If an individual has multiple email addresses, they should be shown in the output file, excluding any email addresses with no value. In this case, the 3rd row with ID 12345 should be removed from the output file.

If an individual has only one record and does not have an email address, that record should be displayed in the output file.

Input File

ID	First Name	Last Name	Email
12345	John	Lavaert	JL@gmail.com
12345	John	Lavaert	JL@AOL.com
12345	John	Lavaert
45678	Ed	Shaw

Output File

ID	First Name	Last Name	Email
12345	John	Lavaert	JL@gmail.com
12345	John	Lavaert	JL@AOL.com
45678	Ed	Shaw

[griffinwelsh · Accepted solution]

@kal-tech See the attached solution. The key is to use a filter and join tool to identify which records do not have email addresses.

[kal-tech]

Thank you griffinwelsh. The issue has been resolved.