Question
Data read from a data source such as a CSV file or database was tabulated and output by Aggregate operation, but the order of the data was different from the expected result.
What is the cause of this?
Answer
Aggregate operation has the following specification limitations.
■ Specification Limitations
・Order of the result data of the aggregate operation is not assured.
Therefore, when data read from a data source such as a CSV file or database is aggregated and output by the operation, the order of the result data is not guaranteed.
■Workaround
As an example of measures, you can use Sort operation to specify the order of the data and output it after the data has been aggregated.
■Supplemental information
Aggregate
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Connector/basic_aggregate.htm
Sort
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Connector/basic_sort.htm
Comments
0 comments
Article is closed for comments.