Hello @Delbert71 , the DQ rules are applied to the data and not the metadata (which is the data type). So unfortunately it is not possible to check the data type this way. If you have a value stored as string, you can test it for proper date formats, numbers etc., but when the attribute is already something different than string (e.g. Integer), you can apply only DQ rules that have the Integer attribute as an input.

What we suggested to other clients, you can do this check via the ONE Desktop plan - you download the metadata for the table (attribute data types) and check the value of it. You can then send the results to your desired destination (DB, file, ...)

Please let me know if this answers your question.

Kind regards,

Anna

Good morning Anna,

Many thanks for your reply.

I think that option will work for me.

Thanks for sharing.

Kind regards

Derek