I have 2 datasets that I want to make sure are in synch, meaning the same value is in each dataset/column. Dataset1 has a column (Integer type) that has 10 digits, and Dataset2 has the same column but its length is 12-13 digits. The difference in length is because in Dataset2, there are trailing zeros. Here is an example of what I am referring to: In DS1/col1 the value is 1234567899In DS2/col1 the value is 123456789900 Regex or SQL? Sample code would be welcome.

DQ Check for same value in 2 different Datasets. | Data Quality & Observability

DQ Check for same value in 2 different Datasets. | Data Quality & Observability | Collibra Community