Data join and filter by Status

[richard24best]

Hi Team,

I receive daily files 1st Jan,2nd Jan,.......31 Dec 2022. And also when the new starts again i start getting the daily files for 2023 - 1st Jan......etc

Got variety of fields - Process name, Status - Y/N, etc

Requirement is that using the yearend file how do I lock 2022 data based on Status = 'Y' and show only 2023 by default in the dashboard. 

Requestor should see 2022 when they select the 2022 as the filter.

Any thoughts/suggestions are much appreciated.

Regards,

Richard

[sidhiq91]

@richard24best Could you please elaborate on your requirement? Also, please post some sample data along with expected output.