locked
How to validate the coming value supposed to be greater than the existing max value? RRS feed

  • Question

  • Hello All, 

    Hope you can share some thoughts on this.

    In my org, we use DQS as a data validation tool. Here is one scenario we found hard to archive. Each month, we get the excels from external parties and one of the column in excel file we hope to make sure this value should be always greater than the max value in database.

    Let's the coming value "Value_Date", we hope this column values are all greater than (select max(value_date) from table1).

    This table is in SQL Server.

    Anyone has idea how I can archive this in DQS?


    Derek

    Sunday, August 2, 2015 2:37 PM