topic Re: Datos no coincidentes(Join) in App Development https://community.qlik.com/t5/App-Development/Datos-no-coincidentes-Join/m-p/2445113#M97618 <P>Try this:</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Load ID,</P> <P>ID as ID_hist</P> <P>from Historico;</P> <P>Load ID, exists(ID_hist, ID) as ID_exists form Mes;</P> Fri, 26 Apr 2024 06:38:07 GMT Vegar 2024-04-26T06:38:07Z Datos no coincidentes(Join) https://community.qlik.com/t5/App-Development/Datos-no-coincidentes-Join/m-p/2445060#M97610 <P>Buen día comunidad</P> <P>&nbsp;</P> <P>Requiero ayuda con lo siguiente, tengo dos tablas:</P> <P>&nbsp;</P> <P>Historico: con el campo ID:[1,2,3,4,5]</P> <P>Mes: ID[1,2,6,7,8]</P> <P>No he podido hallar la forma de cruzar las dos tablas para obtener los registros no coincidentes, lo que deseo es saber mediante un script los registros de la tabla del Mes que no están en el Histórico&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 25 Apr 2024 21:37:17 GMT https://community.qlik.com/t5/App-Development/Datos-no-coincidentes-Join/m-p/2445060#M97610 Alejo527 2024-04-25T21:37:17Z Re: Datos no coincidentes(Join) https://community.qlik.com/t5/App-Development/Datos-no-coincidentes-Join/m-p/2445113#M97618 <P>Try this:</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Load ID,</P> <P>ID as ID_hist</P> <P>from Historico;</P> <P>Load ID, exists(ID_hist, ID) as ID_exists form Mes;</P> Fri, 26 Apr 2024 06:38:07 GMT https://community.qlik.com/t5/App-Development/Datos-no-coincidentes-Join/m-p/2445113#M97618 Vegar 2024-04-26T06:38:07Z