schema check for long type

[rk2019]

Hi Team,

i am doing schema check for one of the long type field where expectation is to have number only without (-) hyphens ex: 1505944477337 but some of the source record is coming like this 00-000-0000 , unfortunately schema check is passing these 00-000-0000 values without error . how do i check and rejects these through schema check.

[vikramk]

Hi @RAVI KUMAR​ ,

You could apply filter for hyphen to capture the dataset and once you cleanse it you can unite the 2 datasets using tunite.

Unfortunately schema check ll check only for datatypes not the content.