topic Expression Builder to catch Phone Number and Gender in Data Quality

Expression Builder to catch Phone Number and Gender

NWQ — Wed, 13 Mar 2024 08:40:40 GMT

Hi,

Would like to know how to i write an expression in tMap component to capture 2 scenario.

1. Phone number column is not in number

2. Gender column is not in Male and Female.

Thank you!

Any additional information to use expression builder for Data Quality module will be great and appreciate that!

Re: Expression Builder to catch Phone Number and Gender

Shicong_Hong — Thu, 14 Mar 2024 07:20:10 GMT

Hello

1. Phone number column is not in number

You can use the built-in function Mathematical.NUM(String s) to validate the number column, returns 1 if it is a numeric data type, otherwise, returns 0;

for example, add the following expression in the filter expression field.

Mathematical.NUM(row1.columnName)==1

2. Gender column is not in Male and Female.

Use the expression:

row1.columName.equals("Male")&&row1.columName.equals("Female")

Regards

Shicong

Re: Expression Builder to catch Phone Number and Gender

NWQ — Fri, 22 Mar 2024 01:35:24 GMT

Thanks it work!