Require solution on below use case

[Rajeevs]

[Anonymous]

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

[Rajeevs]

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

[Anonymous]

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