Forum Discussion
Identify the missing sections in a table
Here's the sample model that helps to identify the missing sections on my real time scenario. There is a table which has different sections - I am extracting only the July, Aug, Sep months of data t...
Here you are. File attached.
Here you are. File attached.
daXtreme I need one more hint/support in this method. In advance you stated 2023 data as well for missing values in "T_FullMonths". In visual at 'Absent' checkbox it lised 2023 and sections. Rather than listing all Year and Month in advance. Is there any possibilities that limited it to report only the existing months listed in "T" table. In other terms, If I include Nov 2022 data sections in "T" table (data source) for this month, I need to manully update the 2022, Nov in "T_FullMonths" table. Just looking for an alternate in that particular method. Any guidance will be appreciated.