https://community.qlik.com/t5/QlikView/Show-the-status-of-customer-that-is-not-present-in-my-main-fact/m-p/1860003#M1216087 <P>Hi Team,</P> <P>Attached the sample data and scenario. 2 input tables - Table1 and Table2. Table1 is main fact table, Table2 is used as mapping table only (key- customerid&amp;date)</P> <P>Highlighted the example in yellow which is the current challenge, customer is not available in oct data but still need to show up as Y in Reconciled? column in frontend (because it has L1 status in table2)</P> <P>Please let me know for an queries. Any suggestions would be really helpful.</P> <P>Thank you so much in advance.</P> <P>Regards</P> <P>Neha</P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 16 Nov 2021 16:37:19 GMT Neha_2227 2021-11-16T16:37:19Z https://community.qlik.com/t5/QlikView/Show-the-status-of-customer-that-is-not-present-in-my-main-fact/m-p/1860003#M1216087 <P>Hi Team,</P> <P>Attached the sample data and scenario. 2 input tables - Table1 and Table2. Table1 is main fact table, Table2 is used as mapping table only (key- customerid&amp;date)</P> <P>Highlighted the example in yellow which is the current challenge, customer is not available in oct data but still need to show up as Y in Reconciled? column in frontend (because it has L1 status in table2)</P> <P>Please let me know for an queries. Any suggestions would be really helpful.</P> <P>Thank you so much in advance.</P> <P>Regards</P> <P>Neha</P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 16 Nov 2021 16:37:19 GMT https://community.qlik.com/t5/QlikView/Show-the-status-of-customer-that-is-not-present-in-my-main-fact/m-p/1860003#M1216087 Neha_2227 2021-11-16T16:37:19Z