Reference:7.Locate and Filter the Record in TSeq

When analyzing the data in the TSeq, you will usually need to search for the records satisfying the conditions according to the requirements. In esProc, if there is a value in a cell, then the value of this cell can be referenced with the cell name.

esProc_tseq_filter1

In esProc, you can either directly select the record from the TSeq according to its position, or compute the position of records satisfying the conditions with the pselect() function, or specify the position of the max or min record as a result of a specified expression with the pmax(), pmin(), and other functions. 

esProc_tseq_filter2

In the TSeq, you can use select() function to filter the data and pick out the record satisfying the specified conditions. After filtering, an RSeq composed of the corresponding records will be returned.

In esProc, to generate a new TSeq, you can choose the desired column to compute based on the data from TSeq or RSeq.

With the new() function, you can select the necessary information from TSeq or RSeq to form a new TSeq.

esProc_tseq_filter3

Of A2 and A3 the results are as follows:

esProc_tseq_filter4

In esProc, you can choose to add the computed column directly to the TSeq. The value in the computed column can be computed based on the data from other columns of TSeq. With derive() function, the computed column can be added for the TSeq. 

esProc_tseq_filter5

After using derive() function to add the computed column, the existing TSeq is changed. As you can see in A1, the TSeqhas been changed:

esProc_tseq_filter6

Advertisements

About datathinker

a technical consultant on Database performance optimization, Database storage expansion, Off-database computation. personal blog at: datakeywrod, website: raqsoft
This entry was posted in Reference and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s