Data quality check

[SahilArora3139]

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)

[BRRLL99]

connect Browse tool to your dataset

it gives quality to about your dataset

[SahilArora3139]

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

[FinnCharlton]

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!