Forum Discussion

SiKing's avatar
SiKing
Community Expert
12 years ago

[Resolved] unique values in DataSource

When I read in values using a DataSource step, I would like to be able to remove duplicates. For me personally, this would only make sense for a single-column of data values. But I suppose there could be a way to specify a column name which would be searched for duplicates.
  • Hi,

    Thanks for the feature request. Can you provide us few use cases where this will be useful?

    Regards,
    Shadid
    SmartBear Sweden.
  • SiKing's avatar
    SiKing
    Community Expert
    I run a SOAP request(s) that fetches back a bunch of values. I would like to iterate over all the values, but only unique ones, passing them to a subsequent request.
  • Yeah Okay.

    I was more thinking in the line that, is there any use cases where it is not possible to do the same operation in the data source itself. For example an excel or jdbc where you prepare it to only have unique values so when you feed this to SoapUI it already has unique values.

    Or is it simply for convenience that, you want SoapUI to take care of this filtering?

    Regards,
    Shadid
    SmartBear Sweden.
  • SiKing's avatar
    SiKing
    Community Expert
    Fetching values from JDBC can already do this.
    I am of the belief (probably in a minority) that for test automation if you use Excel you are doing it wrong; for any value of "it".
  • Hi,

    After some discussion with our Product owner, we decided not to have this feature in SoapUI since it is possible to do the same thing on different data sources. In case, you need this functionality it can be done with a groovy script otherwise, we think it is better to feed SoapUI with a data source which is already filtered and has unique values in such cases.

    Regards,
    Shadid
    SmartBear Sweden