IDEA Data Analysis has, for many years, offered users the ability to use Gap Detection to test for gaps in date sequences based on dates falling on working or weekend days. This has been one of the more invaluable ways that IDEA helps to identify issues with data completeness and integrity.   That said, the…

Join is one of the most powerful capabilities within IDEA Data Analysis Software as it provides an easy to use and flexible way to combine multiple databases into a single dataset.  It is used mainly for two reasons:   Combining fields from two databases into a single database for analysis. For testing data which matches…