compare the count between the two tables

TamilM — Wed, 18 Dec 2013 12:14:56 GMT

Hi,
i have task to compare two views (multiple table combination) or select query with multiple table joined to get count of both views and display this difference in output file,
My output file should display like this
table1 count table2 count Difference
100 500 400
im very new to talend, thanks in advance.

Re: compare the count between the two tables

Anonymous — Wed, 18 Dec 2013 18:09:25 GMT

What about a query like select count(1) as count_rows from table1 where..... and so on.
Add 2 database input components to your job.
Put your query for the tables into them (one by one).
Click on retrieve schema to get a schema from your query.
Create 2 context variables count1 and count2 from type Integer.
You can memorize the received value into a context variable.
Example:
tMysqlInput_1 --> tJavaRow_1
Code for tJava_1:

context.count1 = input_row.count_rows;

Do the same for your table2.
Now you have 2 filled context variables with counters.
By the way, your topic is in the wrong forum!

topic Re: compare the count between the two tables in Talend Studio

compare the count between the two tables

Re: compare the count between the two tables