topic Re: Help me with the logic please in Talend Studio

Help me with the logic please

DEV4 — Sat, 16 Nov 2024 05:13:13 GMT

Hello All,

I have a requirement where I'm extracting the data from a excel file and loading that to target oracle table. Below is how my data looks like.

If there are multiple records per Prospect_ID and if the APPLICANT_SUBMIT_DATE is null, we need to load to target the record where Decision = Y and if more than one row exists with Decision = Y then take the record with maximum Application_Start_Date.

Thanks

Re: Help me with the logic please

Anonymous — Sat, 20 Jul 2019 16:48:05 GMT

Hello, have you tried the following?

tExcelInput -> tFilterRow (filter Decision = Y) -> tAggregateSortRow (Group by Prospect_ID, Entry Team) -> tLogRow

You extract all the information from Excel, filter and delete Decision = N is not relevant information).

By grouping for each Prospect ID and Entry Team you will have each row with a different application date and decision = Y which is what you need to send to the output to save it in a CSV / Database System file.

Greetings,

Re: Help me with the logic please

DEV4 — Sun, 21 Jul 2019 20:39:54 GMT

Thank you for the reply.

I do not want to filter all the data with Decision = N. If there is a single row where Decision=N, that row should be loaded to target.

I should filter Decision=N only when there are multiple records per prospect ID per entry_term, and if the APPLICATION_SUBMIT_DATE is null for those records with same prospect_id, then remove the row or rows with Decision = N, and out of the remaining rows with Decision=Y get the row with MAX Application_Start_Date and load that in to target.

Thank You

Re: Help me with the logic please

DEV4 — Mon, 22 Jul 2019 04:21:05 GMT

Some one please help me on this this is kind of urgent issue. Thank You

Re: Help me with the logic please

mani1304 — Mon, 22 Jul 2019 12:59:54 GMT

filter null dates, then sort on the basis of propect Id, status, submit_date and take the max of each