topic Identify Last Row in tDBinput in Talend Studio

Identify Last Row in tDBinput

heshkaru — Thu, 01 Jun 2023 16:53:41 GMT

Hi,

I have a sequencial job as below image. For each row it should work. But I need to know how to identify whether it is the last row from the selected rows?

Thank you

Heshan Karunaratne

Re: Identify Last Row in tDBinput

anselmopeixoto — Fri, 02 Jun 2023 00:23:15 GMT

Hi @Heshan Karunaratne

I'm not sure what is your use case, but I'd suggest you try the following:

Store the data extracted from tDBInput using a tHashOutput (do this before the subjob shown in the image you sent).
Then use a tHashInput to read the dataset stored in memory (just replace your current tDBInput by a tHashInput).

This way you would know exactly how many rows are stored in memory before processing the dataset.

You could add a sequential column to make it easier to know if the current row is the last row in your dataset.

I hope it helps.

Best regards,

Anselmo

Re: Identify Last Row in tDBinput

Lord-Vader — Fri, 02 Jun 2023 09:29:37 GMT

I am not sure what you are trying to do, but maybe this will help idk.

What you can do is use the tAggregate Component and use the "last" function. You wil get the last row of every selected rows. so if you selected 10 rows, you wil get the 10th row.

(I would recommend to use the tHashInput/Output as the first comment said.)

Click the multi rows add button. Set the function to last, set input to whatever column your requirements are. Then click ok. Set it into a tLogRow and BAM!!

Hope this helps.

Vader out 💪.