Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Grouping rows

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)

 

Labels (3)
2 Replies
TRF
Champion II
Champion II

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.
Anonymous
Not applicable
Author

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.