esProc Download
Recent Comments
Even For OBIEE, its… on 6 Desktop BI Tools Marco on Seven analysis tools: R langua… lkafle on An example to illustrate hadoo… lkafle on Five methods of data consolida… Blog Stats
- 13,744 hits
Category Archives: Reference
Reference:11. Flow of Program in esProc
In esProc, you can use various judgment and loop statements just as in the normal program language to implement the program design of choice structure and repetitive structure. Unlike JAVA and other high level languages, esProc use the straightforward format … Continue reading
Reference:10. Modify Sequence and TSeq
The same syntax for array assignment in Java also applies to the sequence modification in esProc, that is, you can just assign directly to the member at appointed position to implement it. Besides, similar to SQL statement, you can also … Continue reading
Reference:9. Grouping Record in TSeq
To collect statistics and analyze data often requires grouping the records of a TSeq or RSeq according to certain conditions. The commonest group is the Equal Group. Distribute the records from a TSeq or RSeq to several groups according to … Continue reading
Reference:8.Sort on Record in TSeq
Since the field of record has no data type requirement, you can assign any value. To assign the value to another record, you can conveniently implement the foreign key reference. 8 After executing the derive command, in the TSeq of … Continue reading
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 … Continue reading
Reference:6. Collect Statistics on TSeq
To collect statistics based on the data from database, we often perform the count, sum, min value computations, and other operations on the database record. In esProc, you can perform various converge computation in the TSeq, such as count, sum, … Continue reading
Posted in Reference
Leave a comment
Reference:5.Retrieve TSeq from Database
To retrieve TSeq from database, you will have to connect with the relational database in the Datasource Manager of esProc: 1) Click the Tool -> Datasource connection menu item, open the Datasource Manager. 2) Create a new datasource, and select … Continue reading
Reference:4. Use Sequence to Compute
In esProc, not only the ISeq is a sequence, but also the TSeq and RSeq are all sequence. The sequence computation is the basic computation of esProc. As a type of set, sequence can be used for common operations with … Continue reading
Reference:3. Introduction to ISeq
The sequence making up of integers is Integer Sequence or ISeq for short. When defining the ISeq, you can also use the [] to enclose the member for defining the ISeq or use the expression to define it. In esProc, … Continue reading
Reference:2.Sequence and TSeq
Sequence is an ordered set consisting of some data, and the constitutive data of a sequence is called Member. Sequence is equivalent to the array in the high level language. The difference is that the member of sequence does not … Continue reading