Data fusion pipeline- wrangler transformation not working

Asked Dec 10 '19 at 11:56

Active Dec 10 '19 at 16:56

Viewed 480 times

Datafusion pipeline Source is a csv file in GCS Wrangler -- > Tried to validate few columns like below

Mobile_Number(column) -- > send to error --> value matches regex expression - >^[0]?[789]\d{9}$

When the similar transformations are added, wrangler is failing with errors. And also how to check the records that were filtered during validation. I can't even find which validation has failed.

edited Dec 10 '19 at 16:56

theduck

2,589
13
17
23

asked Dec 10 '19 at 11:56

Aruna Jayabalu

Adding the transformations send-to-error MOBILE_PHONE =~ "^[0]?[789]\d{9}$" send-to-error MOBILE_PHONE =~ "(\d)\1{9}" send-to-error FULL_NAME =~ "^[a-zA-Z]+$" – Aruna Jayabalu Dec 10 '19 at 11:59
1

Could you share a screenshot with the error, and an example of the CSV file? – Enrique Zetina Dec 10 '19 at 18:45

Data fusion pipeline- wrangler transformation not working

0 Answers0