http://forums.visokio.com/discussions/tagged/data-quality/feed.rss Mon, 30 Oct 17 20:25:50 -0400 Tagged with data-quality - Visokio Forums en-CA http://forums.visokio.com/discussion/1850/datamanager-custom-alerts-for-data-qualitys Mon, 22 Oct 2012 12:28:41 -0400 JfJf 1850@/discussions
For example, If I have a data stream lets say Shoe Models from sales, and I wanna cross it over with an static price excel sheet so I would be getting a merge between the Shoe Models & Shoe Prices to get my sales data. If a new model is released, it would be registered in the sales, but I need to include it In the Shoe prices so it would be successfully merged and counted; these unsuccessfully merged records would be a part of non-merged records, or in the case that I get a many:many relationship, it would be very useful to have a block or an extension of the data Validation block that would flag custom issues between blocks, so these errors could be fixed faster and easier.

In this shoes example, the solution would be IF I get less records of a particular field in the the merge output than the amount of records from that same field in a previous block, then it would be flagged as [missing records] or simply error.

It would be like adding an additional layer to the formulas that could include the Block name. So a formula which is usually [Function][Field][Record], could be [Function][Block][Field][Record]. I don't know if this is already possible, but it would be useful for data integrity and improved automation.

Thank you, JfJf

]]>