topic Re: Require solution on below use case in Talend Studio

Require solution on below use case

Rajeevs — Mon, 24 Sep 2018 06:38:54 GMT

Re: Require solution on below use case

Anonymous — Mon, 24 Sep 2018 06:46:40 GMT

Hi,

Could you please advise what is your use case and what is your current job design etc. A picture of the input data alone will not help the Talend community members to help you.

Warm Regards,

Nikhil Thampi

Re: Require solution on below use case

Rajeevs — Mon, 24 Sep 2018 07:20:37 GMT

Thanks, Mr. Nikhil on prompt reply. Below is the use case

1. Reading data set from Oracle

2. Sorting columns on Invoice and Receivables

3. Memorize 2 rows

4. want to put this logic '=IF(OR(A2<>A3,AH2<>AH3),AH2,0)

Pls help to arrive this solution

Job design pic is attached.

LPSS.png

Re: Require solution on below use case

Anonymous — Mon, 24 Sep 2018 08:03:25 GMT

Hi,

You can use tOracleInput for first step, tSortRow for sorting (second step).

The third step can be attained by using tMemorize/tHashOutput but you need some tweaks based on your needs.

The if condition can be added using a tjavarow (which can be added either prior to tMemorize or after that based on ypour specific need.

I would suggest to go through the component help document to become more familiar with the components and then try the logic.

Warm Regards,

Nikhil Thampi