topic Re: Reg. data compare and conditional flow in Talend Studio

Reg. data compare and conditional flow

Anonymous — Mon, 26 Jun 2017 07:54:42 GMT

Hi,

I have below scenario, I want to compare the output of tUniqueRow and accordingly either run A or B. Any suggestion how should I go about it.

Brgds,

Sudhir

Re: Reg. data compare and conditional flow

Anonymous — Mon, 26 Jun 2017 08:53:46 GMT

Hello
Basically, we will use runIf connector to fire a subjob base on a condition, but now I don't know what your data comparison logic. Please give us some example data out of tUniqRow1 and tUniqRow2 to explain your logic.

Regards
Shong

Re: Reg. data compare and conditional flow

Anonymous — Mon, 26 Jun 2017 08:58:36 GMT

I need to get count of rows in both tUnique and compare it, if both count
matches it should trigger A or else B

Re: Reg. data compare and conditional flow

Anonymous — Mon, 26 Jun 2017 09:52:05 GMT

@shong wrote:
Hello
Basically, we will use runIf connector to fire a subjob base on a condition, but now I don't know what your data comparison logic. Please give us some example data out of tUniqRow1 and tUniqRow2 to explain your logic.

Regards
Shong

something like this, though I am not sure if this is the best way to implement this. If you can let me know how to compare o/p of two tfilerowcounts

Re: Reg. data compare and conditional flow

Anonymous — Mon, 26 Jun 2017 10:40:18 GMT

Hi,

tfilecount is not necessary as the tuniquerow gives you the number of unique rows by a global variable.

I am able to see a tfilelist component at the front.

Are you going to use multiple files?

If just one file it is simple.

1. Create a tjava

2. Take a subjob ok from tfilelist component and connect to tjava. Nothing required inside tjava

3. From tjava create 2 runif connector and connect to process a and b

4. ((Integer)globalMap.get("tUniqRow_1_NB_UNIQUES")) and ((Integer)globalMap.get("tUniqRow_2_NB_UNIQUES"))is the global variable to get the unique number of rows from both the filters

5. each run if you can use the above variables to do a comparison

For multiple files, I am still thinking how we can go about it. give it a try by following all steps above and taking componentok from tfileinput delimited.

Cheers!
Gatha

Re: Reg. data compare and conditional flow

Anonymous — Mon, 26 Jun 2017 11:12:51 GMT

Thanks, I will try this option.

Re: Reg. data compare and conditional flow

Anonymous — Mon, 26 Jun 2017 13:36:38 GMT

Thanks Gatha ! I could do it and its working for multiple files too. Have a look.

Re: Reg. data compare and conditional flow

Anonymous — Mon, 26 Jun 2017 13:38:58 GMT

That's cool.

Please test this with more number of records in the file.

Please mark my previous comment as solution and give Kudos where ever necessary

Cheers!

Gatha