DrGWright Member

@MarkSnodgrass what I'm getting in the SQL results is any of the program's completion dates, not necessarily having all of the programs complete. So, for example, what I'm seeing is: Agent 1 is completes Program 1 on 2/2/2020, and hasn't completed Program 2 or 3, the data is still giving me the completed date of "Any…

Also, the Program Enrollment Status 1-3 do not correspond to each specific program, it's just an overall status within our LMS.

Thanks, @MarkSnodgrass , and example would be as follows: Agent # Program ID Completion Date 1 12 1/1/2020 1 16 1/7/2020 1 84 1/5/2020 What I want to show is: Agent # Latest Completion Date 1 1/7/2020 I'm wondering if I took out the "Program Title" from the SQL if that would take the duplicate records away, because I don't…

@MarkSnodgrass when I'm validating the data, I'm seeing that the "in" statement is allowing "any of the program completions" to count instead of they must have "all of the programs complete." Any thoughts?

Yes, @MarkSnodgrass , that's what I was missing was the "IN" statement. I haven't worked with SQL in several years and completely forgot about "IN." Thank you SO much!

Thank you so much @DDalt 

That worked BEAUTIFULLY!!!! Thanks so much! @DataMaven 

I'm not using SQL for any of this. I'm still not sure how to simplify. Is there anything within the ETL or Dataflow to help correct this issue?