topic Compare current row with previous row based on some condition in excel file in talend in Talend Studio

Compare current row with previous row based on some condition in excel file in talend

Anonymous — Sat, 16 Nov 2024 07:44:26 GMT

I am creating a job which take input from db and insert in excel file sheet. I want to compare current row with the previous row in excel and get unmatched row copied in to another file. Is that comparing possible?

If yes, Please help me in doing that.

If no, How can I achieve this in alternate way.

Thanks in advance.

Meghana.

Re: Compare current row with previous row based on some condition in excel file in talend

SachinD — Fri, 31 Aug 2018 08:28:13 GMT

Hi @MeghanaKottala

Yes, it can be done using tMap, by keeping previous row column values in variable.

if you want to compare multiple columns with previous rows, you need to add more variables.

I my example i have just compared ID column, you can take more columns if needed.

and add some more logic as per your requirement.

click Accept the solution if it helps,
Also kudos are welcome

Sachin.

Re: Compare current row with previous row based on some condition in excel file in talend

aashish_21nov — Fri, 31 Aug 2018 12:31:07 GMT

Hi @MeghanaKottala,

Appreciate your efforts @SachinD but tMemorizeRow is the component to compare data with previous row.

Re: Compare current row with previous row based on some condition in excel file in talend

SachinD — Sat, 01 Sep 2018 06:32:42 GMT

Yes @aashish you are correct,

we can achive it using tMemorizeRow , but one need to write custom Java code in tJava components.

tMap can keep values between rows and its process from top to bottom order. we can configure to hold the last value of particular columns and compare them with the current row column.

yes you are right if we want to keep more than 2 rows in memory we can use tMemorizeRow, as it can be configured to keep n number of rows in memory.

its also possible with tMap, by increasing no of variables.

we can pick any logic as per our complexity.

Thanks,

Sachin D

Re: Compare current row with previous row based on some condition in excel file in talend

Anonymous — Mon, 03 Sep 2018 06:14:23 GMT

Thanks for the response.

I have used tJava component and stored previous value as context variabe as I need only one value to remember. It's working fine.

Thanks,

Meghana.