how to compare data between two qvd

[#1]

how to compare data is same between 2 similar qvd files

[ramasaisaksoft]

use "qualify"

now 2 tables are different

now create the  variable

Let  vNoofrows1 = NoOfRows('TableName1')

Let  vNoofrows2 = NoOfRows('TableName2')

these will give the no of rows from each table

if u want to compare field wise

count (distinct(t1.id) )

count (distinct(t2.id) )

just do like this and check by column wise, but it is a manual work