https://community.qlik.com/t5/App-Development/Comparison-of-two-QVDs/m-p/2014649#M83843 <P>Hi, you can try just to load them together in Qlik and see what rows are different. Load script could look like this, if both QVD have same column names:</P> <LI-CODE lang="markup">tb1: LOAD *, 1 as ind_tb1 FROM 1qvd; JOIN LOAD *, 1 as ind_tb2 FROM 2qvd; NoConcatenate only_unique_rows: LOAD * RESIDENT tb1 WHERE ind_tb1&lt;&gt;1 or ind_tb2&lt;&gt;1; DROP TABLE tb1;</LI-CODE> <P>Basically, you load your first QVD and mark each row with indicator to know that it comes from 1QVD. You join second QVD with JOIN, so if rows are identical in both QVD it will merge, if not, it will be separate row. We also add indicator ind_tb2. Now we just reload only unique rows in one of two tables. ind_tb1 and ind_tb2 will show you in witch QVD it is unique.</P> Fri, 09 Dec 2022 07:41:31 GMT justISO 2022-12-09T07:41:31Z https://community.qlik.com/t5/App-Development/Comparison-of-two-QVDs/m-p/2014270#M83821 <P>Hello,</P> <P>I want to compare two QVDs and check which rows have data that is only in one QVD and not in both. I hope someone has an helpfull Idea or nows a tool or website that can do this.</P> Thu, 08 Dec 2022 10:02:02 GMT https://community.qlik.com/t5/App-Development/Comparison-of-two-QVDs/m-p/2014270#M83821 bw7 2022-12-08T10:02:02Z https://community.qlik.com/t5/App-Development/Comparison-of-two-QVDs/m-p/2014649#M83843 <P>Hi, you can try just to load them together in Qlik and see what rows are different. Load script could look like this, if both QVD have same column names:</P> <LI-CODE lang="markup">tb1: LOAD *, 1 as ind_tb1 FROM 1qvd; JOIN LOAD *, 1 as ind_tb2 FROM 2qvd; NoConcatenate only_unique_rows: LOAD * RESIDENT tb1 WHERE ind_tb1&lt;&gt;1 or ind_tb2&lt;&gt;1; DROP TABLE tb1;</LI-CODE> <P>Basically, you load your first QVD and mark each row with indicator to know that it comes from 1QVD. You join second QVD with JOIN, so if rows are identical in both QVD it will merge, if not, it will be separate row. We also add indicator ind_tb2. Now we just reload only unique rows in one of two tables. ind_tb1 and ind_tb2 will show you in witch QVD it is unique.</P> Fri, 09 Dec 2022 07:41:31 GMT https://community.qlik.com/t5/App-Development/Comparison-of-two-QVDs/m-p/2014649#M83843 justISO 2022-12-09T07:41:31Z