- Top Category > General Questions > DataSpider Servista > [DataSpider Servista] How do I specify and output only the first and last values of duplicate records when loading a file?
Search via FAQ No.
NEW
[DataSpider Servista] How do I specify and output only the first and last values of duplicate records when loading a file?
I want to delete duplicate records, because the data is not cleansed and there are duplicate records in the file.
How can I specify and output only the first and last values of records with duplicate values when reading a file?
- Category :
Answer
In the [Aggregation] component, it is possible to specify and output only the [First Value] or [Last Value] of the record in which the value of the specified item is duplicated.
Please refer to the following DataSpider Servista help for details of [Aggregation] component.
- [Transform]-[Basic]-[Summarize]
*[Aggregation] component is added from Ver. 4.0SP1.