Data quality check

Question

Hi

i need  help to check the data quality of my input file: (excel /csv)

parameters for the quality check are below:

1) a cell  cannot be null in a particular column (if its null show some errors that time only and stop the workflow)

2) n Column  should not be blank

3) date format should be correct

kindly suggest any tool that can be used to filter out these quality parameters in the data set. (Csv/excel/txt)

FinnCharlton · Answer

Hi @SahilArora3139, one way to do this is to use the message tool. This will check if a certain condition is true, and can error the workflow if it is not. You can use it to check for nulls, blanks and correct date formats using this method:

Hope this helps!

Check Data Quality.yxmd

SahilArora3139 · Answer

Tried using the tool. Not working for what i need .

BRRLL99 · Answer

connect Browse tool to your dataset

it gives quality to about your dataset