topic Re: Grouping rows in Talend Studio

Grouping rows

Anonymous — Sat, 16 Nov 2024 05:25:04 GMT

I have data in a .txt file formatted like this:

        Sample Name      Analyte       Equation       Result
        --------------------------------------------------------------------
        Sample 1         Result        Equation 1     3.6059E-3
                                       Equation 2     2.0701E-4
                                       Equation 3     3.6059E-3
                                       Equation 4     2.0747E-4
        Sample 2         Result        Equation 1     3.5815E-3
                                       Equation 2     1.9839E-4
                                       Equation 3     3.5815E-3
                                       Equation 4     1.9954E-4
        Sample 3         Result        Equation 1     3.5945E-3
                                       Equation 2     2.0606E-4
                                       Equation 3     3.5945E-3
                                       Equation 4     2.0688E-4

I want to group the data of each sample (every 4 rows), but I don't know how when each row does not contain the sample name. How can I do this?

(PS I am using version 4.1.1 & I am new to Talend)

Re: Grouping rows

TRF — Mon, 01 Jul 2019 21:03:04 GMT

Use tMap variables to store sequence value to be reinitialized when the value of 4 is reached. Other tMap variables to store current record values only when the sequence is equal to 1.

Re: Grouping rows

Anonymous — Tue, 02 Jul 2019 15:09:49 GMT

Do you mind elaborating on this a bit? What would this tMap variable look like? My apologies, like I said, I am very new to this.